Hi Thomas, I imported also this file in sqlite3, and it was imported like with preserveWhitespace=true.
I understand changing it now would break existing code based on it, but I feel like by default it should not "change" the data, it should be done intentionally (by setting preserveWhitespace=false). Best regards, Sylvain On Tue, Aug 4, 2015 at 7:45 AM, Thomas Mueller <[email protected] > wrote: > Hi, > > I think I will keep it as it is. > > Regards, > Thomas > > > On Monday, August 3, 2015, Sylvain Pointeau <[email protected]> > wrote: > >> select * from CSVREAD('test.csv','charset=UTF-8 preserveWhitespace=true'); >>> >> >> for the record, the below statement is correct, the previous one was >> incorrect. >> >> select * from CSVREAD('test.csv', null, 'charset=UTF-8 >> preserveWhitespace=true'); >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
