Subject Re: [OT] - country codes (Re: [firebird-support] doing cascade update manually?)
Author Martijn Tonies
> >>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)

And the country code for the top-level-domain, right?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com