[sqlite] Retrieving the table info fails

[Simon Slavin]

On 16 Nov 2015, at 5:51pm, Igor Korot <ikorot01 at gmail.com> wrote:

> It looks like I falsely assumed that it will return an empty string instead.
> Guess I was wrong.

The empty string is a perfectly legitimate default value for a column.  And 
it's not the same as NULL, a different perfectly legitimate default value for a 
column.  These two do not do the same thing:

CREATE TABLE myTable (fred DEFAULT NULL);
CREATE TABLE myTable (fred DEFAULT '');

> Also, are you saying that if I have a integer field with the default value of 
> 1,
> I will not be able to retrieve it with sqliteColumnText()?

Correct.  These two do not do the same thing:

CREATE TABLE myTable (fred DEFAULT 1);
CREATE TABLE myTable (fred DEFAULT '1');

Simon.