German phone and address format?

30/09/2008 - 18:37 von Holz | Report spam
Hi all

Our company is expanding into Europe, Germany being one of the markets, and
we need to get some sample
databases so we can learn the input methods.
We mainly need to learn how 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!

Holz
 

Lesen sie die antworten

#1 Olaf Helper
30/09/2008 - 20:06 | Warnen spam
Hello Holz,

the postal format for addresses are easy:
Firstname Lastname
Street Housenumber
ZIP City
Land

ZIP = Postleitzahlen (PLZ) has 5 digits, see
http://de.wikipedia.org/wiki/Postleitzahl_(Deutschland)
MS Acces list: http://www.bkwald.de/A97/pvb.zip
Overview with old 4 digit PLZ: http://www.greuel.de/karten/akgeb1.htm

Telephone prefix (Telefon Vorwahl) are 3-5 digits.
http://de.wikipedia.org/wiki/Telefonvorwahl

Here some links (all in German):
Telephone numbers: http://de.wikipedia.org/wiki/Rufnummer
Address format definition by German Post Office:
http://www.deutschepost.de/dpag?ski...mp;xmlFile04048

If you have more concrete questions, please post them.

Bye,
Olaf Helper

BTW, your name "sounds very German", it means "Wood" ;-)



"Holz" schrieb im Newsbeitrag
news:
Hi all

Our company is expanding into Europe, Germany being one of the markets,
and we need to get some sample
databases so we can learn the input methods.
We mainly need to learn how 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!

Holz

Ähnliche fragen