Warren Bell wrote:
> 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
Could you send a short code sample for your problem?
It would make it easier for me to look.
In response to
pgsql-jdbc by date
|Next:||From: rw2xg7h02||Date: 2008-08-18 21:40:34|
|Subject: Hint: parseSql(...) in AbstractJdbc2Statement.java can be
|Previous:||From: Craig Ringer||Date: 2008-08-18 03:20:01|
|Subject: Re: Hello|