Problem escaping, nonstandard use of \\ in a string literal

Started by Warren Bellover 17 years ago2 messagesgeneral
Jump to latest
#1Warren 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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Warren Bell (#1)
Re: Problem escaping, nonstandard use of \\ in a string literal

Warren Bell <warren@clarksnutrition.com> 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