Subject Re: [ib-support] Escape strings?
Author Helen Borrie
At 11:02 AM 28/03/2003 +0100, you wrote:
>Hello
>
>How do I escape strings?
>
>This is 'a test' of string escaping.
>
>Should it be: INSERT INTO data VALUES('This is \'a test\' of string
>escaping.')

INSERT INTO data VALUES('This is a ''test'' of string escaping.')
Those are two single-quotes, not a single double-quote. :-))

>Are there any other characters that should be escaped?

No.

heLen