Re: Escaping special characters

[Thom Brown <thombrown@xxxxxxxxx>]

2009/3/17 Thom Brown <thombrown@xxxxxxxxx>

I could be wrong, but shouldn't it be:

INSERT INTO thing (name) VALUES ('Smith E'\\& Jones');

I'm not sure why you're including an extra single or double-quote in the string.

Regards

Thom

Sorry, (damn copy & paste).  I meant:

INSERT INTO thing (name) VALUES (E'Smith \\& Jones');

Thom