Code: Select all
INSERT INTO countries VALUES (73,'France','FR','FRA','1');
INSERT INTO countries VALUES (74,'France, Metropolitan','FX','FXX','1');
Code: Select all
INSERT INTO countries VALUES (73,'France','FR','FRA','1');
BOTH regions and depts are needed. BOTH. Some merchants use regions.
The official reference to follow is ISO-3166-2 FR.
Thats i did in my SQL script.