Subject | Re: [OT] - country codes (Re: [firebird-support] doing cascade update manually?) |
---|---|
Author | Martijn Tonies |
Post date | 2003-12-14T19:33:33Z |
> >>That was then and now is now. Country codes are now much more dynamicthan
> >>they used to be; and there are two standards, not one. So I maintainmy
> >>country tables with a generator and hold both IATA and CCCIT countrycodes,
> >And the country code for the top-level-domain, right?
> >
> > 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)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com