Subject Re: [OT] - country codes (Re: [firebird-support] doing cascade update manually?)
Author Lucas Franzen
David Garamond schrieb:

> Helen Borrie wrote:
>
>>That was then and now is now. Country codes are now much more dynamic than
>>they used to be; and there are two standards, not one. So I maintain my
>>country tables with a generator and hold both IATA and CCCIT country codes,
>
>
> I'm not aware of country codes standard apart from ISO 3166. By "CCCIT"
> do you mean CCITT/ITU-T international calling code?

I don't know what the IATA and CCCIT codes are, but I'm aware of quite a
lot of international country codes (sicne I have to deal with them all
the time).

As there are:
(1) ISO-Alpha-2
(2) numeric (outdated)
(3) ISO3166
(4) ISO3166 numeric

For example the codes for France - Germany - USA - Australia are:
(1) FR - DE - US - AU
(2) 001 - 004 - 400 - 800
(3) FRA - DEU - USA - AUS
(4) 250 - 276 - 840 - 036

Additional there's also the international car sign (which you usually
use when for e.g. postal letters)

Luc.



>