SQLite Forum

Nulls or blanks
Login
It is important that you figure out what values are in those fields.  So use

<code>SELECT FatherID, typeof(FatherID), length(FatherID), hex(FatherID) FROM <tablename></code>

and tell us what it produces for those troublesome fields.