If you store NULL then SQLite will return NULL. Maybe your presentation layer is converting NULL to text.
The literal NULL is used in the query text, or you can call sqlite3_bind_null() for a parameter or sqlite3_result_null() to set the result of a user written function. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Prajeesh Prakash Gesendet: Mittwoch, 05. Dezember 2018 09:35 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] How to Save NULL data to DB Hi Team, How to save NULL parameter into the DB. I saw something like (null) on table but when i am reading from the table it popup as a string not the NULL value. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users