How to Save NULL data to DB

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to Save NULL data to DB

Prajeesh Prakash
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: [EXTERNAL] How to Save NULL data to DB

Hick Gunter
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:[hidden email]] Im Auftrag von Prajeesh Prakash
Gesendet: Mittwoch, 05. Dezember 2018 09:35
An: [hidden email]
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
[hidden email]
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users