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?


Reply via email to