mercredi 14 janvier 2015

sqlite unescaped " character - how to escape double quotes?

I am having trouble importing into sql lite. I am exporting a table from Sql Server into a flat file encoded in UTF-8. And then trying to import the flat file into sqlite db. DB is UTF-8 encoded.


These lines are troublesome (tab delimited, line ends with CRLF):



ID w posid def
1234 bracket 40 "(" and ")" spec...

1234 bracket 40 Any of the characters "(", ")", "[", "]", "{", "}", and, in the area of computer languages, "<" and ">".


Error:


unescaped " character


I have tried replacing the quotes " with double quotes "", still doesn't work.


Import settings: tab separator


.separator " "


.import data.txt words


sqlite Table Schema:



CREATE TABLE words (ID integer NOT NULL, w TEXT NOT NULL, posid TEXT NOT NULL, def TEXT NOT NULL);

Aucun commentaire:

Enregistrer un commentaire