list, I experienced the following situation: * field holding a file identifier (currently only numbers). * the field type is nvarchar (text? affinity). * some file identifiers have leading zeros. * of those file identifiers having leading zeros, some leading zeros are being stripped off (handled like integers), and some leading zeros are not (handled like text). * I am accessing the database with TkSQLite. * I am using the most recent release of Active Tcl 8.5
Checked web for an answer. No joy. I have not checked all of the mailing lists. Question: Am I missing something obvious? How can I ensure consistent behavior? Any thoughts would be appreciated. Thank you in advance. Francis J. Monari monarifj....@juno.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users