European address and phone format?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holz - 30 Sep 2008 17:39 GMT

Hi all

Our company is expanding into Europe and we need to get some sample
databases so we can learn the input methods.
We mainly need to learn how European addresses and Telephone numbers are
formatted? We will be storing the following in a MS-Access / SQL server
database but we need to determine how
1) Customer Name
2) Address1
3) Address2
4) City
5) State/Province
6) ZIP
7) Country (ISO 3166 Country Codes)
8) Currency (ISO 4217 Currency Codes)
9) Telephone numbers: Example xx (x) xxxx - xx xx xx

Any clue or link would be greatly appreciated!

Signature

Holz

Reply to this Message

Russell Fields - 30 Sep 2008 20:01 GMT

Holz,

For addresses, check out Frank's Compulsive Guide to Postal Addresses
http://www.columbia.edu/kermit/postal.html

For phone numbers, check out: http://www.wtng.info/

Also, look at the paragraph on NDD Prefix for phone number formatting
considerations at:
http://www.kropla.com/dialcode.htm

Also, here is a Microsoft site on globalization with general pages on
addresses and phone numbers:
http://www.microsoft.com/globaldev/getWR/steps/wrguide.mspx

RLF

> Hi all
>
[quoted text clipped - 14 lines]
>
> Any clue or link would be greatly appreciated!

Reply to this Message

Holz - 30 Sep 2008 20:34 GMT

Great links, thanks!

> Holz,
>
[quoted text clipped - 31 lines]
>>
>> Any clue or link would be greatly appreciated!

Reply to this Message