Simon Slavin wrote on Tuesday, January 06, 2015 3:00 PM > > On 6 Jan 2015, at 7:49pm, Nelson, Erik - 2 > <erik.l.nel...@bankofamerica.com> wrote: > > > Is there any way to force the bind_text() to store the input text > verbatim? > > Another possibility is that everything is being stored fine, and that > something is changing the type of the result just before you print it. > To check this do something like > > SELECT id,length(id) FROM tester > > and see whether the length is what you'd expect it to be.
It was a source data problem. Someone apparently opened the source CSV file in Excel, which changed the numbers to scientific notation, then they saved it. My bad, I should have checked that first. Many thanks again to you and Dr. Hipp. Erik ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
