On Thu, Nov 17, 2011 at 4:44 PM, Francis J. Monari, Esquire < monarifj....@juno.com> wrote:
> 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 > Are you sure it is SQLite doing the leading-zero stripping, and not Tcl? > > 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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users