escape the ' as '' - thats two 's for the ' you want in your data. INSERT INTO albums VALUES (1, 'Tom''s Diner');
Regards, Dewang Shah Directi ---------------------------------------- Quidquid latine dictum sit, altum sonatur. Whatever is said in Latin sounds profound. -----Original Message----- From: Gianmaria [mailto:[EMAIL PROTECTED] Sent: Friday, December 12, 2003 6:11 PM To: [EMAIL PROTECTED] Subject: [sqlite] special chars in sql query hi, i've a little issue to ask, how can i set a text field or a record via sql query when in the string there's the ' char? i'd like not to substitute this symbol with another one. for example when i have in the sql 'Tom's' he thinks that the string is 'Tom' Excuse me for the stupid question! Gian -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]