Re: International Addresses and Telephones

On Thu, Dec 04, 2003 at 09:53:16AM -0600, Rankin, Randy wrote: > I have a form which captures US addresses ( address, city, state ) and > telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I > need to expand this to capture non-US info, so I was hoping for some > guidance on forms and table structures. I have googled this to death and > still haven't come up with anything. I tend to use an internationalized format for all phone numbers, such as: +CCC (NP)AAAXXXXXXX where: CCC = country code (i.e. 44 for UK, 39 for Italy, etc) NP = optional national prefix (e.g. in the US this is 1) AAA = area code (212 for New York, 6 for Rome, etc) XXXXXXX = actual phone number -- Aj. Sys. Admin / Developer