List of countries and internation dial codes 1

0ddball · Jul 14, 2006

If anyone can use this, then here you go. Some don't have dial codes and I havn't included the table creation script - that's for you to do

This is a perfect target for find and replace to customise it for your schema.

I use this table as a lookup for a few different Dropdown Lists and I have plans for the future to expand the data in it to include stupid things like postal code matching regular expressions, car number plate RegEx, etc.

Any suggestions or coments please post - any flames cos I got something wrong, be nice

Code:

INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (0, 'Afghanistan', '93');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (1, '&Aring;land Islands', '358');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (2, 'Albania', '355');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (3, 'Algeria', '213');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (4, 'American Samoa', '684');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (5, 'Andorra', '376');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (6, 'Angola', '244');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (7, 'Anguilla', '1264');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (8, 'Antarctica', '672');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (9, 'Antigua and Barbuda', '1268');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (10, 'Argentina', '54');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (11, 'Armenia', '374');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (12, 'Aruba', '297');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (13, 'Australia', '61');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (14, 'Austria', '43');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (15, 'Azerbaijan', '994');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (16, 'Bahamas', '1242');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (17, 'Bahrain', '973');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (18, 'Bangladesh', '880');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (19, 'Barbados', '1246');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (20, 'Belarus', '375');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (21, 'Belgium', '32');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (22, 'Belize', '501');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (23, 'Benin', '229');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (24, 'Bermuda', '1441');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (25, 'Bhutan', '1441');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (26, 'Bolivia', '591');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (27, 'Bosnia and Herzegovina', '387');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (28, 'Botswana', '267');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (29, 'Bouvet Island', '47');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (30, 'Brazil', '55');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (31, 'British Indian Ocean territory', '246');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (32, 'Brunei Darussalam', '673');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (33, 'Bulgaria', '359');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (34, 'Burkina Faso', '226');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (35, 'Burundi', '257');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (36, 'Cambodia', '855');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (37, 'Cameroon', '237');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (38, 'Canada', '1');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (39, 'Cape Verde', '238');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (40, 'Cayman Islands', '1345');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (41, 'Central African Republic', '236');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (42, 'Chad', '235');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (43, 'Chile', '56');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (44, 'China', '86');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (45, 'Christmas Island', '618');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (46, 'Cocos (Keeling) Islands', '61');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (47, 'Colombia', '57');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (48, 'Comoros', '269');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (49, 'Congo', '242');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (50, 'Congo, Democratic Republic', '243');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (51, 'Cook Islands', '682');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (52, 'Costa Rica', '506');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (53, 'C&ocirc;te d''Ivoire (Ivory Coast)', '225');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (54, 'Croatia (Hrvatska)', '385');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (55, 'Cuba', '53');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (56, 'Cyprus', '357');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (57, 'Czech Republic', '420');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (58, 'Denmark', '45');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (59, 'Djibouti', '253');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (60, 'Dominica', '1767');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (61, 'Dominican Republic', '1809');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (62, 'East Timor', '670');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (63, 'Ecuador', '593');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (64, 'Egypt', '20');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (65, 'El Salvador', '503');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (66, 'Equatorial Guinea', '240');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (67, 'Eritrea', '291');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (68, 'Estonia', '372');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (69, 'Ethiopia', '251');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (70, 'Falkland Islands', '500');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (71, 'Faroe Islands', '298');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (72, 'Fiji', '679');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (73, 'Finland', '358');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (74, 'France', '33');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (75, 'French Guiana', '240');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (76, 'French Polynesia', '689');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (77, 'French Southern Territories', '');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (78, 'Gabon', '241');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (79, 'Gambia', '220');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (80, 'Georgia', '995');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (81, 'Germany', '49');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (82, 'Ghana', '233');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (83, 'Gibraltar', '350');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (84, 'Greece', '30');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (85, 'Greenland', '299');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (86, 'Grenada', '1473');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (87, 'Guadeloupe', '590');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (88, 'Guam', '1671');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (89, 'Guatemala', '502');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (90, 'Guinea', '224');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (91, 'Guinea-Bissau', '245');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (92, 'Guyana', '592');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (93, 'Haiti', '509');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (94, 'Heard and McDonald Islands', '');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (95, 'Honduras', '504');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (96, 'Hong Kong', '852');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (97, 'Hungary', '36');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (98, 'Iceland', '354');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (99, 'India', '91');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (100, 'Indonesia', '62');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (101, 'Iran', '98');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (102, 'Iraq', '964');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (103, 'Ireland', '353');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (104, 'Israel', '972');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (105, 'Italy', '39');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (106, 'Jamaica', '1876');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (107, 'Japan', '81');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (108, 'Jordan', '962');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (109, 'Kazakhstan', '7');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (110, 'Kenya', '254');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (111, 'Kiribati', '686');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (112, 'Korea (north)', '850');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (113, 'Korea (south)', '82');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (114, 'Kuwait', '965');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (115, 'Kyrgyzstan', '996');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (116, 'Lao People''s Democratic Republic', '856');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (117, 'Latvia', '371');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (118, 'Lebanon', '961');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (119, 'Lesotho', '266');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (120, 'Liberia', '231');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (121, 'Libyan Arab Jamahiriya', '218');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (122, 'Liechtenstein', '423');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (123, 'Lithuania', '370');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (124, 'Luxembourg', '352');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (125, 'Macao', '853');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (126, 'FYR Macedonia', '389');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (127, 'Madagascar', '261');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (128, 'Malawi', '265');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (129, 'Malaysia', '60');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (130, 'Maldives', '960');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (131, 'Mali', '223');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (132, 'Malta', '356');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (133, 'Marshall Islands', '692');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (134, 'Martinique', '596');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (135, 'Mauritania', '222');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (136, 'Mauritius', '230');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (137, 'Mayotte', '269');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (138, 'Mexico', '52');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (139, 'Micronesia', '691');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (140, 'Moldova', '373');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (141, 'Monaco', '377');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (142, 'Mongolia', '976');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (143, 'Montserrat', '1664');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (144, 'Morocco', '212');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (145, 'Mozambique', '258');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (146, 'Myanmar', '95');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (147, 'Namibia', '264');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (148, 'Nauru', '674');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (149, 'Nepal', '977');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (150, 'Netherlands', '31');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (151, 'Netherlands Antilles', '599');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (152, 'New Caledonia', '687');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (153, 'New Zealand', '64');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (154, 'Nicaragua', '505');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (155, 'Niger', '227');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (156, 'Nigeria', '234');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (157, 'Niue', '683');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (158, 'Norfolk Island', '672');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (159, 'Northern Mariana Islands', '1670');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (160, 'Norway', '47');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (161, 'Oman', '968');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (162, 'Pakistan', '92');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (163, 'Palau', '680');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (164, 'Palestinian Territories', '970');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (165, 'Panama', '507');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (166, 'Papua New Guinea', '675');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (167, 'Paraguay', '595');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (168, 'Peru', '51');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (169, 'Philippines', '63');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (170, 'Pitcairn', '');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (171, 'Poland', '48');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (172, 'Portugal', '351');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (173, 'Puerto Rico (1)', '1787');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (174, 'Qatar', '974');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (175, 'R&eacute;union', '262');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (176, 'Romania', '40');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (177, 'Russian Federation', '7');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (178, 'Rwanda', '250');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (179, 'Saint Helena', '290');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (180, 'Saint Kitts and Nevis', '1869');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (181, 'Saint Lucia', '1758');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (182, 'Saint Pierre and Miquelon', '508');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (183, 'Saint Vincent and the Grenadines', '1784');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (184, 'Samoa', '685');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (185, 'San Marino', '378');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (186, 'Sao Tome and Principe', '239');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (187, 'Saudi Arabia', '966');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (188, 'Senegal', '221');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (189, 'Serbia and Montenegro', '381');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (190, 'Seychelles', '248');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (191, 'Sierra Leone', '232');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (192, 'Singapore', '65');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (193, 'Slovakia', '421');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (194, 'Slovenia', '386');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (195, 'Solomon Islands', '677');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (196, 'Somalia', '252');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (197, 'South Africa', '27');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (198, 'South Georgia and the South Sandwich Islands', '');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (199, 'Spain', '34');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (200, 'Sri Lanka', '94');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (201, 'Sudan', '249');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (202, 'Suriname', '597');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (203, 'Svalbard and Jan Mayen Islands', '47');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (204, 'Swaziland', '268');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (205, 'Sweden', '46');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (206, 'Switzerland', '41');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (207, 'Syria', '963');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (208, 'Taiwan', '886');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (209, 'Tajikistan', '992');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (210, 'Tanzania', '255');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (211, 'Thailand', '66');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (212, 'Togo', '228');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (213, 'Tokelau', '690');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (214, 'Tonga', '676');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (215, 'Trinidad and Tobago', '1868');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (216, 'Tunisia', '216');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (217, 'Turkey', '90');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (218, 'Turkmenistan', '993');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (219, 'Turks and Caicos Islands', '1649');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (220, 'Tuvalu', '688');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (221, 'Uganda', '256');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (222, 'Ukraine', '380');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (223, 'United Arab Emirates', '971');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (224, 'United Kingdom', '44');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (225, 'United States of America', '1');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (226, 'Uruguay', '598');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (227, 'Uzbekistan', '998');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (228, 'Vanuatu', '678');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (229, 'Vatican City', '379');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (230, 'Venezuela', '58');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (231, 'Vietnam', '84');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (232, 'Virgin Islands (British)', '1284');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (233, 'Virgin Islands (US)', '1340');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (234, 'Wake Island', '808');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (235, 'Wallis and Futuna Islands', '681');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (236, 'Western Sahara', '');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (237, 'Yemen', '967');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (238, 'Zaire', '243');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (239, 'Zambia', '260');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (240, 'Zimbabwe', '263');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (241, 'Australian External Terretories', '672');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (242, 'Guantanamo Bay', '5399');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (243, 'Global Mobile Satellite System', '881');
INSERT INTO `CountryOptions` (`countryId`, `name`, `dialcode`) VALUES (244, 'Puerto Rico (2)', '1939');

Yet another unchecked rambling brought to you by:
Oddball

johnwm · Jul 14, 2006

Well that will save some research and typing! Thank you.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

List of countries and internation dial codes 1

0ddball

Technical User

johnwm

Programmer

Similar threads

Part and Inventory Search

Sponsor