INSERT INTO dds_country_code_character_set select 17 as character_set, id as country_code_id from dds_country_code;

--France
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (222,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (222,2);

--Belgium
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (222,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (216,2);

--Japan
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (95,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (95,11);

--China
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (42,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (42,12);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (42,13);

--Greece
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (74,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (74,8);

--Italy
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (226,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (226,2);

--Germany
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (223,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (223,2);

--United States
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (201,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (201,1);

--Sweden
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (237,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (237,2);

--Spain
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (236,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (236,2);

--Slovakia
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (234,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (234,3);

--Netherlands
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (231,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (231,2);

--Denmark
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (219,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (219,2);

--Austria
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (215,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (215,2);

--Czech Republic
--INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (218,17);
INSERT INTO dds_country_code_character_set(country_code_id,character_set_encoding_id) VALUES (218,3);


