Simon Slavin wrote:
> On 13 Nov 2009, at 3:30am, Roger Binns wrote:
>
>
>> Simon Slavin wrote:
>>
>>> Integers in all languages I'm aware of are not stored as mantissa/exponent,
>>> they're stored as bits with complete precision.
>>>
>> There is one huge exception I found out the hard way recently: Javascript
>> stores all 'integers' as floating point and so Javascript integers lose
>> precision. For example if you try to use 9223372036854775807 in Javascript
>> it will keep coming back as 9223372036854776000.
>>
>
> JavaScript doesn't have an integer type, just a number type:
>
> var myVariable = 42
> document.writeln ( "myVariable is a " + typeof myVariable )
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.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
