On Jun 25, 2013, at 11:19 AM, Nißl Reinhard <reinhard.ni...@fee.de> wrote:
> because it stays in quotation mode until it finds a further ", which is
> incorrect. Quotation mode may only get activated when " appears at the
> beginning of a column value.
Meh… check the recent "escape quote for csv import" thread…
As mentioned multiple time, by multiple people, on multiple occasions…
7. If double-quotes are used to enclose fields, then a double-quote
appearing inside a field must be escaped by preceding it with
another double quote. For example:
"aaa","b""bb","ccc"
http://tools.ietf.org/html/rfc4180
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
