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!
8164062862089986
gt; select * from text;
01234|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 dis
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 a
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
4 matches
Mail list logo