- 浏览: 234377 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
lanzhiyuan:
楼主还混这里不?NSData *data = [NSURLCo ...
[转] 为UIWebView实现离线浏览 -
hyc4117:
#define OpenSSLRSAPublicKeyFile ...
IOS openssl rsa encrypt/decrypt -
guogongjun:
确实有效,不错,感谢啦大神
[转]安装openfire后admin无法登录管理控制平台 -
xiongyoudou1:
怎么办,而且你那下载的demo和你讲解的不是一样
[转] 为UIWebView实现离线浏览 -
xiongyoudou1:
有问题。执行到方法NSData *data = [NSURLC ...
[转] 为UIWebView实现离线浏览
//The country name and URL comes from the links: //http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2 //http://countrycode.org/ //there are several countries no prefix code: //British Indian Ocean Territory io //Jersey je //Svalbard sj //Western Sahara eh //"ps" for {"Gaza Strip", "970"},{"West Bank", "970"}, //The code XK is being used by the European Commission,[20] Switzerland,[21] //the Deutsche Bundesbank,[22] and other organizations as a temporary country code //for Kosovo // the 3rd colum indicates whether the country code is shared with others // . if it is null, then this is a unique country code mapping // . otherwise, if the value is "1", this one is the chosen to "represent" other countries for now // . if the value is 0, it means it is represented by another country // . if the value is -1, this prefix needs a separate algorithm to decide on its country // international prefix refers to: //http://www.nationsonline.org/oneworld/international-calling-codes.htm // there is minor difference to http://multilingualbooks.com/countrycodes.html //the following IDD is the abbreviation of international direct dialing prefix
Country code related
{"ca", "1", "011", "-1", "-5", "Ottawa", "Canada"}, {"do", "1", "011", "-1", "-4", "Santo Domingo", "Dominican Republic"}, {"us", "1", "011", "-1", "-5", "Washington D. C.", "United States of America"}, {"pr", "1", "011", "-1", "-4", "San Juan", "Puerto Rico"}, // has multiple area codes {"cx", "61", "0011", "0", "7", "Flying Fish Cove", "Christmas Island"}, // collide with au {"cc", "61", "0011", "0", "6.5", "West Island", "Cocos (Keeling) Islands"}, // collide with au {"va", "39", "00", "0", "1", "Vatican City", "Vatican City"}, // collide with it {"it", "39", "00", "1", "1", "Rome", "Italy"}, // collide with va {"im", "44", "00", "0", "0", "Douglas", "Isle of Man"}, // collide with uk/gb {"gb", "44", "00", "1", "0", "London", "United Kingdom"}, {"kz", "7", "810", "0", "6", "Astana", "Kazakhstan"}, // collide with ru {"ru", "7", "810", "1", "3", "Moscow", "Russia"}, // collide with kz {"nf", "672", "00", "0", "11.5", "Kingston", "Norfolk Island"}, {"rs", "381", "99", "1", "1", "Belgrade", "Serbia"}, // collide with xk {"xk", "381", "00", "0"}, // collide with rs {"af", "93", "00", null, "4.5", "Kabul", "Afghanistan"}, {"al", "355", "00", null, "1", "Tirana", "Albania"}, {"dz", "213", "00", null, "1", "Algiers", "Algeria"}, {"as", "1684", "011", null, "-11", "Pago Pago", "American Samoa"}, {"bs", "1242", "011", null, "-5", "Nassau", "Bahamas"}, {"bh", "973", "00", null, "3", "Manama", "Bahrain"}, {"bd", "880", "00", null, "6", "Dhaka", "Bangladesh"}, {"bb", "1246", "011", null, "-4", "Bridgetown", "Barbados"}, {"by", "375", "810", null, "3", "Minsk", "Belarus"}, {"be", "32", "00", null, "1", "Brussels", "Belgium"}, {"bz", "501", "00", null, "-6", "Belmopan", "Belize"}, {"bj", "229", "00", null, "1", "Porto-Novo", "Benin"}, {"bm", "1441", "011", null, "-4", "Hamilton", "Bermuda"}, {"bt", "975", "00", null, "6", "Thimphu", "Bhutan"}, {"bo", "591", "0010", null, "-4", "Sucre", "Bolivia"}, {"ba", "387", "00", null, "1", "Sarajevo", "Bosnia and Herzegovina"}, {"bw", "267", "00", null, "2", "Gaborone", "Botswana"}, {"br", "55", "0014", null, "-3", "Brasilia", "Brazil"}, {"vg", "1284", "011", null, "-4", "Road Town", "British Virgin Islands"}, {"bn", "673", "00", null, "8", "Bandar Seri Begawan", "Brunei"}, {"bg", "359", "00", null, "2", "Sofia", "Bulgaria"}, {"bf", "226", "00", null, "0", "Ouagadougou", "Burkina Faso"}, {"mm", "95", "00", null, "6.5", "Naypyidaw", "Myanmar"}, {"bi", "257", "00", null, "2", "Bujumbura", "Burundi"}, {"kh", "855", "001", null, "7", "Phnom Penh", "Cambodia"}, {"cm", "237", "00", null, "1", "Yaounde", "Cameroon"}, {"cv", "238", "00", null, "-1", "Praia", "Cape Verde"}, {"ky", "1345", "011", null, "-5", "George Town", "Cayman Islands"}, {"cf", "236", "00", null, "1", "Bangui", "Central African Republic"}, {"td", "235", "15", null, "1", "N'Djamena", "Chad"}, {"cl", "56", "00", null, "-4", "Santiago", "Chile"}, {"cn", "86", "00", null, "8", "Beijing", "China"}, {"co", "57", "005", null, "-5", "Bogota", "Colombia"}, {"km", "269", "00", null, "3", "Moroni", "Comoros"}, {"ck", "682", "00", null, "-10", "Avarua", "Cook Islands"}, {"cr", "506", "00", null, "-6", "San Jose", "Costa Rica"}, {"hr", "385", "00", null, "1", "Zagreb", "Croatia"}, {"cu", "53", "119", null, "-5", "Havana", "Cuba"}, {"cy", "357", "00", null, "2", "Nicosia", "Cyprus"}, {"cz", "420", "00", null, "1", "Prague", "Czech Republic"}, {"cd", "243", "00", null, "1", "Kinshasa", "Democratic Republic of the Congo"}, {"dk", "45", "00", null, "1", "Copenhagen", "Denmark"}, {"dj", "253", "00", null, "3", "Djibouti", "Djibouti"}, {"dm", "1767", "011", null, "-4", "Roseau", "Dominica"}, {"ec", "593", "00", null, "-5", "Quito", "Ecuador"}, {"eg", "20", "00", null, "2", "Cairo", "Egypt"}, {"sv", "503", "00", null, "-6", "San Salvador", "El Salvador"}, {"gq", "240", "00", null, "1", "Malabo", "Equatorial Guinea"}, {"er", "291", "00", null, "3", "Asmara", "Eritrea"}, {"ee", "372", "00", null, "2", "Tallinn", "Estonia"}, {"et", "251", "00", null, "3", "Addis Ababa", "Ethiopia"}, {"fk", "500", "00", null, "-4", "Stanley", "Falkland Islands"}, {"fo", "298", "00", null, "0", "Torshavn", "Faroe Islands"}, {"fj", "679", "00", null, "12", "Suva", "Fiji"}, {"fi", "358", "00", null, "2", "Helsinki", "Finland"}, {"fr", "33", "00", null, "1", "Paris", "France"}, {"pf", "689", "00", null, "-10", "Papeete", "French Polynesia"}, {"ga", "241", "00", null, "1", "Libreville", "Gabon"}, {"gm", "220", "00", null, "0", "Banjul", "The Gambia"}, {"ge", "995", "810", null, "4", "Tbilisi", "Georgia"}, {"de", "49", "00", null, "1", "Berlin", "Germany"}, {"gh", "233", "00", null, "0", "Accra", "Ghana"}, {"gi", "350", "00", null, "1", "Gibraltar", "Gibraltar"}, {"gr", "30", "00", null, "2", "Athens", "Greece"}, {"gl", "299", "009", null, "-3", "Nuuk", "Greenland"}, {"gd", "1473", "011", null, "-4", "St. George's", "Grenada"}, {"gu", "1671", "011", null, "10", "Hagatna", "Guam"}, {"gt", "502", "00", null, "-6", "Guatemala City", "Guatemala"}, {"gn", "224", "00", null, "0", "Conakry", "Guinea"}, {"gw", "245", "00", null, "0", "Bissau", "Guinea-Bissau"}, {"gy", "592", "00", null, "-4", "Georgetown", "Guyana"}, {"ht", "509", "00", null, "-5", "Port-au-Prince", "Haiti"}, {"hn", "504", "00", null, "-6", "Tegucigalpa", "Honduras"}, {"hk", "852", "001", null, "8", "Hong Kong", "Hong Kong"}, {"hu", "36", "00", null, "1", "Budapest", "Hungary"}, {"is", "354", "00", null, "0", "Reykjavik", "Iceland"}, {"in", "91", "00", null, "5.5", "New Delhi", "India"}, {"id", "62", "001", null, "7", "Jakarta", "Indonesia"}, {"ir", "98", "00", null, "3.5", "Tehran", "Iran"}, {"iq", "964", "00", null, "3", "Baghdad", "Iraq"}, {"ie", "353", "00", null, "0", "Dublin", "Republic of Ireland"}, {"il", "972", "00", null, "2", "Jerusalem", "Israel"}, {"ci", "225", "00", null, "0", "Yamoussoukro", "Ivory Coast"}, {"jm", "1876","011", null, "-5", "Kingston", "Jamaica"}, {"jp", "81", "010", null, "9", "Tokyo", "Japan"}, {"jo", "962", "00", null, "2", "Amman", "Jordan"}, {"ke", "254", "000", null, "3", "Nairobi", "Kenya"}, {"ki", "686", "00", null, "12", "Tarawa", "Kiribati"}, {"kw", "965", "00", null, "3", "Kuwait City", "Kuwait"}, {"kg", "996", "00", null, "6", "Bishkek", "Kyrgyzstan"}, {"la", "856", "00", null, "7", "Vientiane", "Laos"}, {"lv", "371", "00", null, "2", "Riga", "Latvia"}, {"lb", "961", "00", null, "2", "Beirut", "Lebanon"}, {"ls", "266", "00", null, "2", "Maseru", "Lesotho"}, {"lr", "231", "00", null, "0", "Monrovia", "Liberia"}, {"ly", "218", "00", null, "2", "Tripoli", "Libya"}, {"li", "423", "00", null, "1", "Vaduz", "Liechtenstein"}, {"lt", "370", "00", null, "2", "Vilnius", "Lithuania"}, {"lu", "352", "00", null, "1", "Luxembourg", "Luxembourg"}, {"mo", "853", "00", null, "8", "Macau", "Macau"}, {"mk", "389", "00", null, "1", "Skopje", "Republic of Macedonia"}, {"mg", "261", "00", null, "3", "Antananarivo", "Madagascar"}, {"mw", "265", "00", null, "2", "Lilongwe", "Malawi"}, {"my", "60", "00", null, "8", "Kuala Lumpur", "Malaysia"}, {"mv", "960", "00", null, "5", "Male", "Maldives"}, {"ml", "223", "00", null, "0", "Bamako", "Mali"}, {"mt", "356", "00", null, "1", "Valletta", "Malta"}, {"mh", "692", "00", null, "12", "Majuro", "Marshall Islands"}, {"mr", "222", "00", null, "0", "Nouakchott", "Mauritania"}, {"mu", "230", "020", null, "4", "Port Louis", "Mauritius"}, {"yt", "262", "00", null, "3", "Mamoudzou", "Mayotte"}, {"mx", "52", "00", null, "6", "Mexico City", "Mexico"}, {"fm", "691", "011", null, "11", "Palikir", "Federated States of Micronesia"}, {"md", "373", "00", null, "2", "Chisinau", "Moldova"}, {"mc", "377", "00", null, "1", "Monaco", "Monaco"}, {"mn", "976", "001", null, "8", "Ulan Bator", "Mongolia"}, {"me", "382", "99", null, "1", "Podgorica", "Montenegro"}, {"ms", "1664", "011", null, "-4", "Plymouth", "Montserrat"}, {"ma", "212", "00", null, "0", "Rabat", "Morocco"}, {"mz", "258", "00", null, "2", "Maputo", "Mozambique"}, {"na", "264", "00", null, "1", "Windhoek", "Namibia"}, {"nr", "674", "00", null, "12", "Yaren", "Nauru"}, {"np", "977", "00", null, "5.75", "Kathmandu", "Nepal"}, {"nl", "31", "00", null, "1", "Amsterdam", "Netherlands"}, {"an", "599", "00", null, "-4", "Willemstad", "Netherlands Antilles"}, {"nc", "687", "00", null, "11", "Noumea", "New Caledonia"}, {"nz", "64", "00", null, "12", "Wellington", "New Zealand"}, {"ni", "505", "00", null, "-6", "Managua", "Nicaragua"}, {"ne", "227", "00", null, "1", "Niamey", "Niger"}, {"ng", "234", "009", null, "1", "Abuja", "Nigeria"}, {"nu", "683", "00", null, "-11", "Alofi", "Niue"}, {"kp", "850", "00", null, "9", "Pyongyang", "North Korea"}, {"mp", "1670", "011", null, "10", "Capital Hill", "Northern Mariana Islands"}, {"no", "47", "00", null, "1", "Oslo", "Norway"}, {"om", "968", "00", null, "4", "Muscat", "Oman"}, {"pk", "92", "00", null, "5", "Islamabad", "Pakistan"}, {"pw", "680", "00", null, "9", "Melekeok", "Palau"}, {"pa", "507", "00", null, "-5", "Panama", "Panama"}, {"pg", "675", "05", null, "10", "Port Moresby", "Papua New Guinea"}, {"py", "595", "002", null, "-4", "Asuncion", "Paraguay"}, {"pe", "51", "00", null, "-5", "Lima", "Peru"}, {"ph", "63", "00", null, "8", "Manila", "Philippines"}, {"pn", "870", "00", null, "-8", "Adamstown", "Pitcairn Islands"}, {"pl", "48", "00", null, "1","Warsaw", "Poland"}, {"ps", "970", "00", null}, {"pt", "351", "00", null, "0", "Lisbon", "Portugal"}, {"qa", "974", "00", null, "3", "Doha", "Qatar"}, {"cg", "242", "00", null, "1", "Brazzaville", "Republic of the Congo"}, {"ro", "40", "00", null, "2", "Bucharest", "Romania"}, {"rw", "250", "00", null, "2", "Kigali", "Rwanda"}, {"bl", "590", "00", null, "-4", "Gustavia", "Saint Barthelemy"}, {"sh", "290", "00", null, "0", "Jamestown", "Saint Helena, Ascension and Tristan da Cunha"}, {"kn", "1869", "011", null, "-4", "Basseterre", "Saint Kitts and Nevis"}, {"lc", "1758", "011", null, "-4", "Castries", "Saint Lucia"}, {"mf", "1599", "011", null, "-4", "Marigot", "Collectivity of Saint Martin"}, {"pm", "508", "00", null, "-3", "Saint-Pierre", "Saint Pierre and Miquelon"}, {"vc", "1784", "011", null, "-4", "Kingstown", "Saint Vincent and the Grenadines"}, {"ws", "685", "00", null, "-11", "Apia", "Samoa"}, {"sm", "378", "00", null, "1", "City of San Marino", "San Marino"}, {"st", "239", "00", null, "0", "Sao Tome", "Sao Tome and Principe"}, {"sa", "966", "00", null, "3", "Riyadh", "Saudi Arabia"}, {"sn", "221", "00", null, "0", "Dakar", "Senegal"}, {"sc", "248", "00", null, "4", "Victoria", "Seychelles"}, {"sl", "232", "00", null, "0", "Freetown", "Sierra Leone"}, {"sg", "65", "001", null, "8", "Singapore", "Singapore"}, {"sk", "421", "00", null, "1", "Bratislava", "Slovakia"}, {"si", "386", "00", null, "1", "Ljubljana", "Slovenia"}, {"sb", "677", "00", null, "11", "Honiara", "Solomon Islands"}, {"so", "252", "00", null, "3", "Mogadishu", "Somalia"}, {"za", "27", "09", null, "2", "Pretoria", "South Africa"}, {"kr", "82", "001", null, "9", "Seoul", "South Korea"}, {"es", "34", "00", null, "1", "Madrid", "Spain"}, {"lk", "94", "00", null, "5.5", "Sri Jayawardenapura-Kotte", "Sri Lanka"}, {"sd", "249", "00", null, "3", "Khartoum", "Sudan"}, {"sr", "597", "00", null, "-3", "Paramaribo", "Suriname"}, {"sz", "268", "00", null, "2", "Lobamba", "Swaziland"}, {"se", "46", "00", null, "1", "Stockholm", "Sweden"}, {"ch", "41", "00", null, "1", "Bern", "Switzerland"}, {"sy", "963", "00", null, "2", "Damascus", "Syria"}, {"tw", "886", "002", null, "8", "Taipei City", "Taiwan"}, {"tj", "992", "810", null, "5", "Dushanbe", "Tajikistan"}, {"tz", "255", "000", null, "3", "Dodoma", "Tanzania"}, {"th", "66", "001", null, "7", "Bangkok", "Thailand"}, {"tl", "670", null, null, "9", "Dili", "East Timor"}, {"tg", "228", "00", null, "0", "Lome", "Togo"}, {"tk", "690", "00", null, "-10", "Nukunonu", "Tokelau"}, {"to", "676", "00", null, "13", "Nuku'alofa", "Tonga"}, {"tt", "1868", "011", null, "-4", "Port of Spain", "Trinidad and Tobago"}, {"tn", "216", "00", null, "1", "Tunis", "Tunisia"}, {"tr", "90", "00", null, "2", "Ankara", "Turkey"}, {"tm", "993", "810", null, "5", "Ashgabat", "Turkmenistan"}, {"tc", "1649", "011", null, "-5", "Cockburn Town", "Turks and Caicos Islands"}, {"tv", "688", "00", null, "12", "Funafuti", "Tuvalu"}, {"ug", "256", "000", null, "3", "Kampala", "Uganda"}, {"ua", "380", "810", null, "2", "Kiev", "Ukraine"}, {"ae", "971", "00", null, "4", "Abu Dhabi", "United Arab Emirates"}, {"uy", "598", "00", null, "-3", "Montevideo", "Uruguay"}, {"vi", "1340", "00", null, "-4", "Charlotte Amalie", "United States Virgin Islands"}, {"uz", "998", "810", null, "5", "Tashkent", "Uzbekistan"}, {"vu", "678", "00", null, "11", "Port Vila", "Vanuatu"}, {"ve", "58", "00", null, "-4.5", "Caracas", "Venezuela"}, {"vn", "84", "00", null, "7", "Hanoi", "Vietnam"}, {"wf", "681", "19", null, "12", "Mata-Utu", "Wallis and Futuna"}, {"ye", "967", "00", null, "3", "Sana'a", "Yemen"}, {"zm", "260", "00", null, "2", "Lusaka", "Zambia"}, {"zw", "263", "00", null, "2", "Harare", "Zimbabwe"}
Area code
{"ca", "Canada", "600, 403, 587, 780, 825, 236, 250, 604, 778, 204, 431, 506, 709, 902, 226, 249, 289, 343, 365, 416, 519, 613, 647, 705, 807, 905, 902, 418, 438, 450, 514, 579, 581, 819, 873, 306, 867"}, {"do", "Dominican Republic", "809, 829, 849"}, {"pr", "Puerto Rico", "787, 939"}, //add toll-free numbers in the NANP. we take it as a country. "tf" is unique {"tf", "Toll-free numbers", "800, 888, 877, 866, 855, 844, 833, 822, 880, 881, 882, 883, 884, 885, 886, 887, 889"}
相关推荐
`country_code` varchar(100) NOT NULL DEFAULT '' COMMENT '国家代码', `country_name` varchar(100) NOT NULL DEFAULT '' COMMENT '英文国家名称', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=260 ...
country code : ISO-3166 2-letter country code, 2 characters cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 200 characters admin1 code : fipscode (subject to change ...
1. Enter a new item in the My Autocomplete window called country (assuming you have a country lookup table). 2. Change the type to Command. 3. Enter the following SQl (as an example) SELECT country...
`countrycode` varchar(255) NULL, PRIMARY KEY (`id`) ); 插入数据 INSERT country ( `countryname`, `countrycode` ) VALUES ( '中国', 'CN' ), ( '美国', 'US' ), ( '俄罗斯', 'RU' ), ( '英国', 'GB' ), ...
CREATE TABLE `msg_country_code` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name_en` varchar(100) DEFAULT NULL COMMENT '国际名称', `name_cn` varchar(100) DEFAULT NULL COMMENT '中文名称', `name_short`...
CREATE TABLE `tbl_country` ( `id` int(11) NOT NULL AUTO_INCREMENT, `country` varchar(50) COLLATE utf8_bin DEFAULT NULL, `state` varchar(50) COLLATE utf8_bin DEFAULT NULL, `city` varchar(50) ...
EXEC sp_addextendedproperty 'MS_Description', N'邮政编码', 'schema', 'dbo', 'table', 'PE_Address', 'column', 'ZipCode' GO EXEC sp_addextendedproperty 'MS_Description', N'是否默认', 'schema', 'dbo', '...
CREATE TABLE `API_location_country` ( `id` int(11) NOT NULL, `name_en` varchar(255) DEFAULT NULL COMMENT '英文名', `name_zh-Hans` varchar(255) DEFAULT NULL COMMENT '简体中文名', `name_fr` varchar...
学习Mybatis 目录 一。 二。数据库表的建立 三。使用XML方式配置 环境搭建 1.创建maven项目 在Intellij IDEA中创造maven项目 项目创建完成后,我们需要添加一些依赖才能使接下来的工作能够... ` countrycode ` varchar
8 // This database has one table (pmp_countries) with 3 columns (country_id, country_code, country_name) 9 // It has like 237 records of all the countries I could think of. 10 String fileName = "c:/...
哦! 我的模特儿 ... " country_code " int , " default_language " int ); CREATE TABLE " languages " ( " id " int PRIMARY KEY , " code " varchar ( 2 ) NOT NULL , " name " varchar NOT NULL );
DATA: NO_FLIGHTS TYPE NUMBER, NO_PASSENGERS TYPE NUMBER, DISTANCE TYPE LENGTH, HEIGHT TYPE LENGTH, CITY_CODE TYPE CODE, COUNTRY_CODE TYPE CODE. 数据类型可以在程序内部定义(dìngyì),但只能程序内部用...
The only source of any storage location information is the sysindexes table, which keeps track of the address of the root page for every index, and the first IAM page for the index or table....
CREATE TABLE `region` ( `id` varchar(20) NOT NULL, `name` varchar(100) DEFAULT NULL, `parent_id` varchar(20) DEFAULT NULL, `type` varchar(16) DEFAULT NULL COMMENT 'COUNTRY(国家)、PROVINCE(省)...
return fullCode; // blog type } @Column 注解将属性映射到列。 @Entity public class Flight implements Serializable { ... @Column(updatable = false, name = "flight_name", nullable = false, length=50...
Get Country by IP; Bypass Captcha; Get Book from ISBN; Get Amazon Sales Rank; Pattern Match Word; Suggest Spelling; Google Translate; Corner GIF; Rounded Table; Display Bing Map Real world solutions...
zip_code VARCHAR2(75), credit_rating VARCHAR2(9), sales_rep_id NUMBER(7), region_id NUMBER(7), comments VARCHAR2(255), CONSTRAINT s_customer_id_pk PRIMARY KEY (id), CONSTRAINT s_customer_credit...
Base Country/Region, Tax Settings, and Language 50 Default language 51 Currency Settings 52 Presentation Settings 52 Button Settings 53 Product Settings 54 Product Page Settings 56 Shopping ...
This book will teach you advanced techniques in machine learning with the latest code in R 3.3.2. You will delve into statistical learning theory and supervised learning; design efficient algorithms; ...
表 DDL create table app_user ( id bigint not null auto_increment, account_expired bit not null, account_locked bit not null, address varchar(150), city varchar(50), country varchar(100), postal_code ...