国际国家分区(州，省，地区等)的列类型和大小 [英] Column type and size for international country subdivisions (states, provinces, territories etc)

问题描述

如果这是重复的话，我深表歉意.

I apologize if this is a duplication.

您将使用哪种列标准化来存储国际国家细分数据?

What column standardization would you use for storing international country subdivision data?

例如，如果只是美国和加拿大，我认为所有细分都使用2个字符的缩写...这可能会导致使用Char(2)

For example, if it was just US and Canada I believe all subdivisions have a 2-character abbreviation... which might lend to a Char(2)

这在国际上不可能是可持续的，以免我们假设只有1296(A-Z，0-9)个细分.

This cannot possibly be sustainable internationally lest we presume there are only 1296 (A-Z, 0-9) subdivisions.

我一直没有找到这些的ISO列表，甚至没有指示如何存储它们.

I've been unsuccessful locating an ISO list of these or even an indication of how to store them.

很好，我现在不需要全部了解，但我想知道有一个标准以及需要存储的标准信息.

That's fine, I don't need to know them all now but I would like to know that there is a standard and what standard info to store as needed.

谢谢

看来我可以使用ISO 3166-2标准来做到这一点: http://en.wikipedia.org/wiki/ISO_3166-2

It appears that I can accomplish this using the ISO 3166-2 standard: http://en.wikipedia.org/wiki/ISO_3166-2

可在此处浏览为数据集: http://www.commondatahub.com/live/geography/state_province_region/iso_3166_2_state_codes

Browsable as a dataset here: http://www.commondatahub.com/live/geography/state_province_region/iso_3166_2_state_codes

推荐答案

据我所知，因为这是国家问题，所以没有国际标准

As far as I know there are no international standards because it's a national issue

带英国...

• 该分部是威尔士，苏格兰，英格兰，北爱尔兰吗?没有缩写.
• 县:是柴郡"("Ches.")还是高地和岛屿"(无缩写)
• 邮政地区:Rutland仍是邮政县，但不是官方县

您的问题可以假设为联邦机构(根据我所在的瑞士)，但这不适用于大多数国家的许多国家. Kanton 与瑞士一样，在邮政地址或邮政编码中也没有.

Your question arguably assumes a federal structure (as per Switzerland where I am) but this won't apply to many if most countries. Carrying on with Switzerland, Kanton does not feature in postal addresses or post codes either.

如果有ISO标准，则国家或地方自豪感会在您的网站上立即惹恼下注者.

If there is an ISO standard, then national or local pride will annoy punters as soon as it's on your web site.

我个人不喜欢浏览网站上的状态"下拉列表.在英国(我的国籍)或我的住所(瑞士)对我来说都没有意义.

Personally, I dislike wading through a "state" dropdown on a web site. It has no meaning for me in either UK (my nationality) or my residence (Switzerland).

您最好坚持使用美国和加拿大以及非美国/加拿大"的州.请勿强行或假定细分.

You may be best to stick states from US and Canada and "non US/Canada". Don't force or assume a sub-division.

编辑，2012年6月.

Edit, Jun 2012.

我现在住在马耳他.我既没有州，县，也没有坎顿.请不要坚持.

I now live in Malta. I have neither state, county, nor Kanton. Please don't insist.

英国的任何大城市通常都不会提到县(英格兰+威尔士)/地区(苏格兰).

Any big cities in the UK don't normally mention county (England+Wales)/region (Scotland).

这篇关于国际国家分区(州，省，地区等)的列类型和大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！