Has anybody suggested just shoving these into a MySQL database? The
guys who design databases spend a lot of time figuring out how to do
fast indexing and accessing--why not use it?
John
mrock wrote:
> Just how do I set up the program to test the values as alphabetic rather
> than numbers?
>
> -----Original Message-----
> From: slug@nks.net [mailto:slug@nks.net] On Behalf Of Kwan Lowe
> Sent: Wednesday, March 31, 2004 2:12 PM
> To: slug@nks.net
> Subject: Re: [SLUG] big numbers
>
>
>
>>
>>I have a program that analyses calls to phone numbers. (yes, this is
>
> the
>
>>same program that I have struggle with for some time now) The data
>
> file
>
>>is sorted on phone number (area code and the number) that makes it a
>
> 10
>
>>digit number. My comparisons fail at 2 to the 31st power. My last
>>phone number that works is 2147493101. 2 to the 31st power is
>>2147483648. I think this is also the 2 Gbit limit I ran into in much
>>older systems. I am running RH 8.0.
>>
>>How do I construct a test using numbers larger than this if the
>
> program
>
>>ignores all logic at this point?
>
>
> Any reason why you're using numerical values for the phone number?
> Compare the
> numbers as strings rather than INTs and you'll have no limit errors.
> I've
> tested 60 characters without problem.
>
>
>
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 19:52:18 EDT