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 into text form before being stored." I changed the column type to BLOB. Same result. A UPC field surely is not any sort of numerical value. For instance, you cannot add two UPCs and return a valid result. I just need to be spun around and pointed in the right direction! -- __________________________________________________________________ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world! 8164062862089986280348253421170679 http://pi314.at PI VOBISCUM! ================================================================== _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
