Re: [sqlite] numbers in nvarchar fields (text? affinity)

2011-11-17 Thread Richard Hipp
On Thu, Nov 17, 2011 at 5:23 PM, Simon Slavin wrote: > > On 17 Nov 2011, at 9:44pm, Francis J. Monari, Esquire wrote: > > > * 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 tex

Re: [sqlite] numbers in nvarchar fields (text? affinity)

2011-11-17 Thread Simon Slavin
On 17 Nov 2011, at 9:44pm, Francis J. Monari, Esquire wrote: > * 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). Check to see that the affinity for that column is string, no

Re: [sqlite] numbers in nvarchar fields (text? affinity)

2011-11-17 Thread Richard Hipp
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

[sqlite] numbers in nvarchar fields (text? affinity)

2011-11-17 Thread Francis J. Monari, Esquire
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 l