On 17 Sep 2012, at 4:05pm, John Clegg <john.cl...@nailsea.net> wrote:
> Yes, that was the problem thanks. Even though sqlitebrowser declared them > as empty with '' ! No, actually that's your problem. '' is exactly the way to define something as an empty string. To supply a null you would have to supply NULL, without quotes. And there's no way to do that in, for example, a CSV file. Still you now understand the issues and have a working result, so congratulations all round. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users