-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 08/03/12 11:59, Marc L. Allen wrote: > I use Navicat Lite, and it apparently treats an empty string as a NULL > when displaying.
It is far more likely to display the empty string as an empty string and to also display null as an empty string (by default) otherwise the nulls will litter your output which often isn't helpful. The SQLite shell does exactly the same thing by default. You can however tell the SQLite shell to display null as a string of your choice, but then you have the problem of telling the difference between that and a string of the same value. Navicat probably has a similar setting somewhere. Incidentally my Python SQLite wrapper includes a shell, which you can use without knowing anything about Python: http://apidoc.apsw.googlecode.com/hg/shell.html One of the things it does is to colour output which means you could tell the difference between the null value (shown in red) and a string (shown in yellowish). You can also tell the difference between the integer 3 and the string "3" due to the colour. Makes life a lot easier. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk9ZQ1kACgkQmOOfHg372QQbdACg1CrjbyGXu0UaZX+DzFDD+mCY /ssAoIct31OJ5JDZRilBuPtN9+6x9cro =066G -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users