Liam Healy wrote:
With the quotes removed, null values come out as nothing beteween
the delimiters, e.g.
2007-06-08,70,70,5,70,70,5,,,,,,,,
ends with eight null values. Sqlite interprets each as the empty
string "",
which is not the same thing. I presume if it said NULL it would be
right,
but I can't figure out how to make the script output NULL instead of
nothing
(and Oracle's NVL doesn't do the right thing for me). So is there a
way to
have SQLite interpet a missing value as NULL?
Liam,
It won't do you any good to get Oracle to output NULL, SQLite will
import that as a string 'NULL' not as a null value. There is no way to
get SQLite to import null values. All you can do is run a few update
statements after you do the import that change the empty strings into
real nulls.
update table t set coln = null where coln = '';
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
