| From: | Warren Bell <warren(at)clarksnutrition(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Problem escaping, nonstandard use of \\ in a string literal |
| Date: | 2008-08-14 02:04:02 |
| Message-ID: | 48A39292.9020600@clarksnutrition.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)clarksnutrition(dot)com
--
Thanks,
Warren Bell
909-645-8864
warren(at)clarksnutrition(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-08-14 03:19:56 | Re: Problem escaping, nonstandard use of \\ in a string literal |
| Previous Message | Craig Ringer | 2008-08-14 01:58:11 | Re: PostgreSQL and SVN - help me... |