John Machin wrote:
Ummmm what about quoting the quote character? Line-ending characters
e.g. \r and \n?
sqlite> .mode csv
sqlite> select 1, 'He said "Hello".', 3;
1,"He said "Hello".",3
should be
1,"He said ""Hello"".",3
John,
This works for me using sqlite 3.5.3
sqlite> .mode csv
sqlite> select 1, 'test "quoted" text', 'more';
1,"test ""quoted"" text",more
What version are you using?
I seem to recall that SQLite is better about generating valid CSV data
than it it is at reading such data. I haven't looked at the import code
for a while though.
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
