"Paul Nash" <[EMAIL PROTECTED]> writes:
> I have data that includes both quote and apostrophe characters. What regime
> can I use to make this work? Are there escape characters in SQL for these ?
Surround your text string to be inserted in single quotes, and duplicate
embedded single quotes (i.e. replace embedded single quotes with two
consecutive single quotes). Keep individual double quotes as individual
double quotes (i.e. don't duplicate them):
sqlite> create table x (s text);
sqlite> insert into x values ('abc''def"efg');
sqlite> select * from x;
s = abc'def"efg
Derrell
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
