[yunqa.de] Re: How TDISQLITE3Statement.column_str16 deal with NULL values?
- From: Delphi Inspiration <delphi@xxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Fri, 31 Aug 2012 11:30:46 +0200
On 31.08.2012 04:04, coolspace wrote:
> As TDISQLite3Statement.column_str16 function returns unicodestring
> results, so what happens if the real value is NULL?
SQLite's automatic type conversion applies, so
TDISQLite3Statement.Column_Str16() returns an empty string ('') for a
NULL value.
Use TDISQLite3Statement.Column_Type() to distinguish a NULL value from a
real empty string value. It returns SQLITE_NULL for NULL and SQLITE_TEXT
for text.
For details, see the DISQLite3 documentation for sqlite3_column_blob().
It covers all sqlite3_column_xxx() functions and includes a table which
shows how SQLite applies the automatic type conversions.
Ralf
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
