Обсуждение: Backslashes in Strings being removed

Hi All,

How should the backslash character be excaped before storing in pgsql? I
assumed it would be another backslach, but that doesn't seem to work and
the backslash is dropped.

My first post and excuse me if this is the wrong place or a frequently
asked question. I did not find any posts specific to this, but many of
you must have encountered it.

Greg Alton
ActivSoftware
http://www.activsoftware.com

On 01/06/2005 20:12 Greg Alton wrote:
> Hi All,
>
> How should the backslash character be excaped before storing in pgsql? I
> assumed it would be another backslach, but that doesn't seem to work and
> the backslash is dropped.
>
> My first post and excuse me if this is the wrong place or a frequently
> asked question. I did not find any posts specific to this, but many of
> you must have encountered it.

Use PreparedStatements and the driver will correctly escape it for you.

--
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+