X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ffusionax%2FAnciens.sql;h=af12e111875b8bc535be6d9f3fd1007ba6cfbc0c;hb=3422f7193e38e67054d2ecda2f4a68b64bd310ef;hp=4736e2d140dee9a24fc0c973c43639af1e5b655d;hpb=a48b23c3d3e357a2f6e776f452074fe0ee5d594f;p=platal.git

diff --git a/modules/fusionax/Anciens.sql b/modules/fusionax/Anciens.sql
index 4736e2d..af12e11 100644
--- a/modules/fusionax/Anciens.sql
+++ b/modules/fusionax/Anciens.sql
@@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS fusionax_anciens (
   INDEX (pid)
 ) ENGINE=InnoDB, CHARSET=utf8;
 
-LOAD DATA LOCAL INFILE '{?}Anciens.txt' INTO TABLE `fusionax_anciens` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
+LOAD DATA LOCAL INFILE '{?}Anciens.txt' INTO TABLE `fusionax_anciens` CHARACTER SET utf8 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
 (AN, ax_id, @login, @password, promotion_etude, @gpe_promo, Nom_patronymique, partic_patro, prenom, Nom_usuel, partic_nom,
   Nom_complet, @civilite, Code_nationalite, @type, corps_sortie, @StringDate_deces, grade, Mel_usage, Mel_publiable, @xxx, Mob_publiable,
   tel_mobile, @xxx, @xxx, @xxx, @xxx, @xxx, @xxx, @xxx, @X_M_D, @xxx, @xxx, @xxx, @xxx, @xxx, @xxx, @Type_adr,