Karen,
Certainly a quandary. There are many different country lists. One of the
official standard organizations I used was
http://www.iso.org/iso/country_codes
ISO 3166 Maintenance agency
(ISO 3166/MA) - ISO's focal point for country codes
The existence of various country codes developed by different organizations
can
be confusing if you exchange goods or information in our ever more integrated
world. To make sure that communication works you need an accepted, up-to-date
country code standard.
ISO 3166 is this commonly accepted International Standard and the ISO 3166/MA
has been updating it since 1974.
Browse through the pages on our Web site:
* Check what's new,
* Learn that even without knowing it you are benefitting from ISO 3166,
* Download lists of country names and code elements,
* Buy ISO 3166 databases,
* View updates and
* See how ISO 3166 works. Part of the problem with country names is the
need to
provide for historical and political considerations. The Wikipedia article
http://en.wikipedia.org/wiki/Country_code is helpful.
I have a table of country info I would be willing to share. Its definition
follows. It is pretty much up to date. Email me private if you wish a copy.
Table: ApLookupCountry
Descr: Lookup Standard Country Names and other info
No. Column Name Attributes
--- ------------------ ------------------------------------------------------
1 CountryName Type : TEXT 35 NOT NULL
Consrnt: PRIMARY KEY
Comment: Country Name per USPS Intl Mail Manual
2 CntryFIPSCode Type : TEXT 2
Comment: ApSys FIPS Pub 10-2 two char country
code
3 CntryISO2Char Type : TEXT 2
Comment: ApSys ISO Std 3166 two char country
code
4 CntryISO3Char Type : TEXT 3
Comment: ApSys ISO Std 3166 three char country
code
5 CntryUNNbr Type : INTEGER
Comment: ApSys United Nations ISO Std 3166
three digit number
6 CntryPostalFmt Type : TEXT 10
Comment: Format for Postal Mail Code
7 CntryCityLineFmt Type : TEXT 2
Comment: Format for assembling City Line in
Address
8 CntryIntlCdReq Type : TEXT 4
Comment: ApSys Sw "Yes" International prefix
Code required
9 CntryCityCdReq Type : TEXT 4
Comment: ApSys Sw "Yes" City Code required in
dial sequence
10 CntryIDDPrefix Type : INTEGER
Comment: ApSys Intl Telcom Union 1-,2-,3-Digit
country calling prefix
11 CntryCurrencyCode Type : TEXT 3
Comment: ApSys ISO Standard 4217 three char
bank currency code
12 CntryCurrencyNbr Type : INTEGER
Comment: ApSys Country currency Number
13 CntryCurrencyName Type : TEXT 40
Comment: ApSys Country currency name
14 CntryComment Type : TEXT 40
Comment: ApSys Country additional comment
15 CntryAudAction Type : TEXT 4
Default: IAdd
Comment: ApSys Reason Action Taken
16 CntryAudDate Type : DATE
Comment: TrgMnt Date Action Taken
17 CntryAudTime Type : TIME
Comment: TrgMnt Time Action Taken
18 FChrCountryName Type : TEXT 1
Compute: (SGET(CountryName,1,1))
Current number of rows: 235
Jim Bentley
American Celiac Society
[email protected]
tel: 1-504-737-3293
>
>From: "[email protected]" <[email protected]>
>To: RBASE-L Mailing List <[email protected]>
>Sent: Thu, February 17, 2011 10:00:04 AM
>Subject: [RBASE-L] - OT - geography lesson
>
>I have what I thought was a pretty up to date Countries table from one of my
>clients. I know that countries are changing all the time... but still I'm
>confused.
>
>I don't see anything for Belgium. Isn't that a country still?
>
>And what's up with Germany? Is there just one Germany now? I have a couple
>addresses that say "West Germany", and I'm wondering if that should now be
>just
>"Germany".
>
>Thanks!
>
>Karen
>
