Re: [sqlite] Syntax for sql 'insert' for text with comma

Hi, text constants have to be set between single quotes: insert into sometable values ( 5 , 'text' ) If the text contains a single quote, double it: insert into sometable values ( 5 , 'Don''t do this' ) Martin Mauricio schrieb: > Hi, > > I would like to > > insert into sometable values (

[sqlite] Syntax for sql 'insert' for text with comma

Hi, I would like to insert into sometable values ( someid , text ) ; but 'text' contains a few commas, and then it would look like (...) values ( someid , text , text2 , text3 ) ; Is there a syntax to do that properly, maybe like C string constants ("text,\"text\",text\n")? Thanks, Maurício