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.
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.