_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
When trying to load a data file with ,"", sequences (for empty field), there
are quote escape related errors.
Manually converting ,"", to ,, allows the file to be loaded. According to
RFC4180, the double quote is an escaped quote if found inside a string. The
leading quote should not be considered an escaped quote. The ,"", pattern
is very common for denoting empty field.
- Re: [sqlite] BETWEEN and explicit collation assignment Clemens Ladisch
- Re: [sqlite] BETWEEN and explicit collation assignment Igor Tandetnik
- Re: [sqlite] BETWEEN and explicit collation assignment James K. Lowden
- Re: [sqlite] BETWEEN and explicit collation assignment Nico Williams
- Re: [sqlite] BETWEEN and explicit collation assignment Konrad Hambrick
- Re: [sqlite] BETWEEN and explicit collation assignment Roman Fleysher
- Re: [sqlite] BETWEEN and explicit collation assignment James K. Lowden
- Re: [sqlite] BETWEEN and explicit collation assignment Roman Fleysher
- Re: [sqlite] BETWEEN and explicit collation assignment James K. Lowden
- Re: [sqlite] BETWEEN and explicit collation assignment Konrad Hambrick
- [sqlite] v3.8 .import misbehaves tonyp
- Re: [sqlite] v3.8 .import misbehaves Richard Hipp
- Re: [sqlite] v3.8 .import misbehaves tonyp
- Re: [sqlite] v3.8 .import misbehaves Richard Hipp
- Re: [sqlite] v3.8 .import misbehaves tonyp
- Re: [sqlite] v3.8 .import misbehaves Simon Davies
- Re: [sqlite] v3.8 .import misbehaves tonyp
- Re: [sqlite] v3.8 .import misbehaves tonyp
- Re: [sqlite] v3.8 .import misbehaves Simon Davies
- Re: [sqlite] v3.8 .import misbehaves Richard Hipp
- Re: [sqlite] v3.8 .import misbehaves Simon Slavin