>-----Mensaje original----- >De: Jean-Christophe Deschamps <j...@antichoc.net> >Reply-to: General Discussion of SQLite Database ><sqlite-users@sqlite.org> >Para: General Discussion of SQLite Database <sqlite-users@sqlite.org> >Asunto: Re: [sqlite] Trouble inserting null value from txt file >Fecha: Fri, 08 Apr 2011 19:40:07 +0200
>It's impossible when you use standard sqlite3 command line utility. In >your particular case you have 2 options: either write your own >application that will recognize some kind of value as null and insert >it instead of plain text, or you can use temporary table like this: >Another way is to use Pavel's suggestion to reserve some rare arbitrary >string and use an insert trigger to convert the value into actual SQL null. >BTW, beware that triggers can slow down insert rate seriously. Hi jean Thanks and I will consider. Regards. Cristian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
