subject:"\[sqlite\] Confused by import of NULL values from CSV file"

Re: [sqlite] Confused by import of NULL values from CSV file

2010-11-22 Thread Jean-Christophe Deschamps

>I import a CSV flat file into a table (using sqliteman as GUI). The >flat file has NULL values as simply no data between two delimiters (I >use 'tab' as Delimiter). > >The resulting table does not treat 'no data' between 2 delimiters as >NULL. When I run CHECK constraints etc. on it it

Re: [sqlite] Confused by import of NULL values from CSV file

2010-11-22 Thread Igor Tandetnik

rf rf wrote: > I import a CSV flat file into a table (using sqliteman as GUI). The flat file > has NULL values as simply no data between two > delimiters (I use 'tab' as Delimiter). In CSV format, there is no way to distinguish between NULL and '' (an empty string). --

[sqlite] Confused by import of NULL values from CSV file

2010-11-22 Thread rf rf

Hello hopefully someone can help me out on this item I import a CSV flat file into a table (using sqliteman as GUI). The flat file has NULL values as simply no data between two delimiters (I use 'tab' as Delimiter). The resulting table does not treat 'no data' between 2 delimiters as NULL.