I did a dump from my MySql database and there is string field which value is: D'Angelo
The sql sentence generate is this from mysqldump:
INSERT INTO myTable VALUES ('D\'Angelo');
I tested the same sentence in MySql and works fine but in ingres doesn't.
Here is the error:
Error: com.ingres.gcf.util.SqlEx: Unmatched quote, parenthesis, bracket or brace., SQL State: 42000, Error Code: 802835
I imagine there is something to do with ingres jdbc driver. I read this: JDBC Driver - Ingres Community Wiki
but I haven't found anything.
Nothing similar in: Java Code Samples - Ingres Community Wiki