Re: Passing strings with quotation marks into SQLite

sergey_sikorsky wrote:
> 
> Is there any way to pass a string with single and double quotation 
> marks at the same time into SQLite?
> 

INSERT INTO aux_table(name,val) VALUES('opa','''"');
SELECT val FROM aux_table;
'"

Putting two ' in a row results in a single ' in the
string.  Same as in Pascal.  Its an SQL thing.


-- 
D. Richard Hipp -- drh-X1OJI8nnyKUAvxtiuMwx3w@xxxxxxxxxxxxxxxx -- 704.948.4565


To unsubscribe from this group, send an email to:
sqlite-unsubscribe-VgYJa0VH1e9BDgjK7y7TUQ@xxxxxxxxxxxxxxxx

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/