On 2015-07-30 09:05 PM, Sylvain Pointeau wrote: > Le jeudi 30 juillet 2015, Simon Slavin <slavins at bigfraud.org> a ?crit : > >> <https://tools.ietf.org/html/rfc4180> >> >> The CSV importing part of the SQLite shell tool implements this very well. >> >> Simon. >> > > No it does not implement the rule 5 correctly: > > Each field may or may not be enclosed in double quotes (however > some programs, such as Microsoft Excel, do not use double quotes > at all). If fields are not enclosed with double quotes, then > double quotes may not appear inside the fields. > > > Why sqlite keeps the quoted string in the database? Except of this, it > would work well I would say
This is not correct, SQLite follows the standard correctly. Could you provide us with an example CSV file that fails to import correctly for you?