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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
