On 13 Aug 2011, at 7:58am, matthew (matthew.jsoft) white wrote: > I've modified all scripts which replaces empty strings with 'null' , and > every things hunky dory. I was just wondering if sq3 has some kind of > mechanism to parse blank records as null instead of empty strings.
Probably not, since all the parts of SQLite consider the two things to be completely different. A zero-length string is a known string value that has no characters in it. A NULL value is a sign that you don't know what value belongs in that field. There are plenty of places where you might find some records with one and other records with the other, and your application must treat them differently. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
