Geek Answers Handbook

How to avoid double quotes?

I am having problems importing to sql lite. I am exporting a table from Sql Server to a flat file encoded in UTF-8. Then try to import the flat file into sqlite db. DB is encoded in UTF-8 encoding.

These lines are complex (tab delimiter, 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 "symbol

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

Import Options: Tab Separator

.separator ""

.import data.txt words

sqlite table schema:

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

Update: Anyway, adding a hash at the beginning of the def field in Sql Server worked:

update the words set def = '#' + def

I don’t know why this is so. This worked, but it added an unwanted character to the field.

+6
1

, , .

(, char (1), char (2)...), , , . , -, , - . , , , , .

before import:

update [table] set comment = REPLACE(comment, CHAR(13), '-*-')
update [table] set comment = REPLACE(comment, CHAR(10), '%-$-%')
update [table] set comment = REPLACE(comment, '"', '%-&-%')

after import:

update [table] set comment = REPLACE(comment, '-*-', CHAR(13))
update [table] set comment = REPLACE(comment, '%-$-%', CHAR(10))
update [table] set comment = REPLACE(comment, '%-&-%', '"')
+3

More articles:


All Articles