Martin Engelschalk wrote:
Hi all,
The problem seems to be that sqlite makes a difference between an empty
string and a null value.
Therefore, your query has to check both.
In Oracle (and problaby others) the datatype "Varchar2" can be used to
treat an empty string as a null value.
Does anyone know if there is a way to do this in sqlite?
Martin,
When you create the table you can tell sqlite to use an empty string as
the default value if nothing is entered.
Check the column-constraint description in the CREATE TABLE writeup on
the syntax web page.
Gerry
--
------------------
Gerry Snyder
American Iris Society Director, Symposium Chair
in warm, winterless Los Angeles -- USDA zone 9b, Sunset 18-19
