On 11/13/09 6:31 , "Dan Bishop" <danbisho...@gmail.com> wrote:
> Microsoft Excel has a similar problem. I ran into it back when I was > working in a credit union and tried to import a CSV file containing > credit card numbers. Wouldn't have noticed except that credit card > numbers are 16 digits long and double only has 15 digits of precision. Well in that case and for once, I must say the problem is not Excel's, it's yours: credit card "numbers" are not numbers at all, but strings, that just happen to use digits only. You should have imported them as text, not as numbers. Excel had no way to guess. Jean-Denis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users