Re: [sqlite] Leading zeros disappear

Thanks to all who replied! Single quotes? How simple...I used double quotes... Ted -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world!

Re: [sqlite] Leading zeros disappear

1234|01234 1234|1234 Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqlite.org on behalf of Ted Rolle, Jr. Sent: Wed 5/19/2010 2:36 PM To: SQLite Database Subject: [sqlite] Leading zeros disappear I'm entering UP

Re: [sqlite] Leading zeros disappear

On Wed, May 19, 2010 at 03:36:03PM -0400, Ted Rolle, Jr. scratched on the wall: > I'm entering UPCs. > > 0071318119 becomes 71318119. This is not good, or expected, for that > matter Are you entering 0071318119 (a number) or are you entering '0071318119' (a string)? The number is already

[sqlite] Leading zeros disappear

I'm entering UPCs. 0071318119 becomes 71318119. This is not good, or expected, for that matter . The column is specified as TEXT. I thought that TEXT values went in 'as entered'. After reading the docs, Section 2.0: "If numerical data is inserted into a column with TEXT affinity it is converted