If I write out data in csv format using SQLite3 shell, it doubles up
all the quote characters. Any ideas how can I stop it doing this?
C:\sqlite>sqlite3 test.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table test ( f1 varchar(100) );
sqlite> insert into test values('test 1');
sqlite> insert into test values('test "2"');
sqlite> .mode csv
sqlite> .output test.csv
sqlite> select * from test;
sqlite> .quit
C:\sqlite>type test.csv
"test 1"
"test ""2"""
C:\sqlite>sqlite3 test.db
SQLite version 3.6.22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .mode csv
sqlite> delete from test;
sqlite> .import test.csv test
sqlite> select * from test;
"""test 1"""
"""test """"2"""""""
sqlite>
Phil Hibbs.
--
Don't you just hate self-referential sigs?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
