Merge remote branch 'origin/platal-1.0.1'

[platal.git] / modules / fusionax / Activites.sql

diff --git a/modules/fusionax/Activites.sql b/modules/fusionax/Activites.sql
index 653ec74..e412b15 100644 (file)
--- a/modules/fusionax/Activites.sql
+++ b/modules/fusionax/Activites.sql
@@ -18,7 +18,7 @@ CREATE TABLE IF NOT EXISTS `fusionax_activites` (
   INDEX (jobid)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-LOAD DATA LOCAL INFILE '{?}Activites.txt' INTO TABLE `fusionax_activites` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
+LOAD DATA LOCAL INFILE '{?}Activites.txt' INTO TABLE `fusionax_activites` CHARACTER SET utf8 FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n'
 (AC, ax_id, Code_etab, Raison_sociale, Libelle_fonctio, Annuaire,
 @Ligne1, @Ligne2, @Ligne3, @code_postal, @ville, @zip_cedex, @etat_distr, @pays, @tel, @fax, @StringDate_maj);