Re: Problem escaping, nonstandard use of \\ in a string literal
Re: Problem escaping, nonstandard use of \\ in a string literal
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Warren Bell writes: > I am having a problem with escaping characters after upgrading to 8.3. I > have changed the postgresql.conf file to contain: > standard_conforming_strings = on > ... > I am not escaping this character in my code. I am assuming that the > driver is escaping it. I am using the postgresql-8.3-603.jdbc3.jar as > the driver. Does 8.3-603 claim to support standard_conforming_strings = on? (That's an honest question --- I don't know.) I think you should probably be asking about this on pgsql-jdbc. You're more likely to get a knowledgeable answer there. regards, tom lane
Problem escaping, nonstandard use of \\ in a string literal
От:
Warren Bell <warren@clarksnutrition.com>
Дата:
I am having a problem with escaping characters after upgrading to 8.3. I have changed the postgresql.conf file to contain: standard_conforming_strings = on I do not get the error: nonstandard use of \\ in a string literal anymore but now I am having a problem escaping certain characters like the apostrophe \'. I am now getting the following error: syntax error at or near "S" at character 282 that is referring to an apostrophe in an insert statement. I am not escaping this character in my code. I am assuming that the driver is escaping it. I am using the postgresql-8.3-603.jdbc3.jar as the driver. I see that you can escape by doing E'Joe\'s', but how do I get this to work without going through my code and shouldn't this be done by the driver. How do I get this all to work? -- Thanks, Warren Bell 909-645-8864 warren@clarksnutrition.com -- Thanks, Warren Bell 909-645-8864 warren@clarksnutrition.com
