Re: [sqlite] NULL vs ''

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ted Rolle, Jr. wrote: > When I .import a file into a table, || results in a value of '' for the > data item. > How can I get a NULL value stored? The SQLite shell cannot read your mind to determine if a zero length string should be a zero length strin

[sqlite] NULL vs ''

When I .import a file into a table, || results in a value of '' for the data item. How can I get a NULL value stored? This also happens when the item is at the end (EOL) of the row. Currently, I: UPDATE table SET value=NULL where value=''; Ted --- _