Chapter 10. ISO-3166 and Other Country Codes
ISO 3166 is a three-part standard for encoding the names of countries, dependent territories, and special areas of geographical interest and their principal subdivisions (e.g., provinces or states). It began in 1974 and has been updated on a regular basis as countries change names, disappear, or are reabsorbed into other nations.
10.1. ISO 3166-1
Part one of the standard is a set of codes: a two-letter alpha code, a three-letter alpha code, and a three digit code. The two-letter alpha code is the most important. It is embedded in lots of other standards and we computer geeks know it has the Internet’s country code for top-level domains.
Except for the numeric codes, ISO 3166 codes have been adopted in ...
Get Joe Celko's Data, Measurements and Standards in SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
