European sample databases?

[Holz]

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 00 44 (0) 7919 591 264

Any clues, or link that can help us will be greatly appreciated.

 

[Jerry Whittle]

Don't even attempt to put an input mask on the PostalCode (not ZIP) and
Telephone number fields. They are too different between the various countries.

Also you might need a Address3 field as some get rather verbose.

 

[Administrator]

Don't even attempt to put an input mask on the PostalCode (not ZIP) and
Telephone number fields. They are too different between the various
countries.

Also you might need a Address3 field as some get rather verbose.