Basically I have gathered enough information from the help everyone has provided to solve my problem. If anyone needs xls files with country code, exhange and other related numbering information this site has them, some free, some not...
www.numberingplans.com Thanks again for the help everyone. Mike ----- Original Message ----- From: "Michael Tangorre" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 11:23 AM Subject: Re: numbers too big > I just found this site: > http://www.1areacodescountrycodes.com/all-country-code-numbers-countrycodes.htm > > which shows some 5 digit country codes... > > > ----- Original Message ----- > From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, June 13, 2003 11:14 AM > Subject: RE: numbers too big > > > > No specific proof, but thinking about it logially > > > > International dialing allow 4 for Expansion (there aer some 3 digit > codes), > > For Regional Exchanges allow 4 digits (9999 Regions), Local Exchanges > allow > > 4 digits, that leaves you five digits spare for individual phones. > > > > That would give you > > 9999 countries, > > 9999 Regions/Country, > > 9999 Local Exchanges > > 99999 Phones/Exchange. > > > > Therefore you could use a bigint (64 bit number) to hold the data. > > > > Personally I think these numbers allow for quite a large range. > > > > Jason Lees > > Development Team Leader > > National Express. > > > > > > -----Original Message----- > > From: Michael Tangorre [mailto:[EMAIL PROTECTED] > > Sent: 13 June 2003 15:57 > > To: CF-Talk > > Subject: Re: numbers too big > > > > > > Can you confirm this? I would need hard proof. > > > > I appreciate the insight however. > > > > Mike > > > > ----- Original Message ----- > > From: "Jason Lees (National Express)" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, June 13, 2003 10:48 AM > > Subject: RE: numbers too big > > > > > > > Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, > > even > > > with the International diaing code. > > > > > > Jason Lees > > > Development Team Leader > > > National Express. > > > > > > > > > -----Original Message----- > > > From: Michael Tangorre [mailto:[EMAIL PROTECTED] > > > Sent: 13 June 2003 15:25 > > > To: CF-Talk > > > Subject: numbers too big > > > > > > > > > I have some really large number ranges that I need to store in a SQL > > Server > > > 2K DB. > > > > > > The numbers are of the following size: > > > > > > range start > > > 000000000000000000000000000000 > > > > > > range end > > > 999999999999999999999999999999 > > > > > > That was one generic example. Basically the number represents a phone > > number > > > range and I have a range for each country in the world that has > telephone > > > service. What would be the best way to store it these ranges so that I > > can > > > run a query that says, select country name where #phoneNumber# is > within > > > the range. > > > > > > I tried inporting the values in as bigints.. no dice, by the way this > info > > > is coming in from an excel sheet. > > > > > > > > > Thanks, > > > > > > Michael Tangorre > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
