Passing strings with quotation marks into SQLite

Hello ALL,

Test table structure:

create table AUX_TABLE(    
NAME     varchar(255) not null,    
VAL     varchar(255)
);

SQLite version 2.7.3
Enter ".help" for instructions
sqlite> INSERT INTO aux_table(name, val) VALUES("opa", "'t");
sqlite> INSERT INTO aux_table(name, val) VALUES("opa", '"t');
sqlite> INSERT INTO aux_table(name, val) VALUES("opa", '\'t');
   ...>

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

Thanks.

Sergey Sikorskiy


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get 128 Bit SSL Encryption!
http://us.click.yahoo.com/JjlUgA/vN2EAA/xGHJAA/EbFolB/TM
---------------------------------------------------------------------~->

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/