0

I'm doing an import of my csv file in my mysql database (interclassement utf8_general_ci). The file use UTF-8 charset encoding and I set UTF-8 on the import page... but that is the result : "é" ==> "é" ....

So my question is : why I have this basic problem on charset with a config import seems good ? Have you an idea to solve the problem ?

Thanks for help :)

The result :

enter image description here

I do this :

enter image description here

Server version: 5.6.17 - MySQL Community Server (GPL) with Wamp On Windows 8.1 Pro

NIF
  • 462
  • 2
  • 7
  • 23
  • How do you import your csv file? – akasummer Jun 24 '15 at 11:48
  • I set a print screen in my initial post to see you how I do :) – NIF Jun 24 '15 at 12:23
  • possible duplicate of [How to avoid Junk/garbage characters while reading data from multiple languages?](http://stackoverflow.com/questions/29881114/how-to-avoid-junk-garbage-characters-while-reading-data-from-multiple-languages) – Rick James Jun 26 '15 at 01:01
  • Voted to close: Mojibake. See [duplicate](http://stackoverflow.com/questions/29881114/how-to-avoid-junk-garbage-characters-while-reading-data-from-multiple-languages/29907185#29907185) for discussion and solution, including how to recover the data via a pair of `ALTER TABLEs`. – Rick James Jun 26 '15 at 01:02

1 Answers1

0

OK. Partially SOLVED :

The problem was : I create database with the the default collation (swedish). So I was changed the database collation, the table collation and the columns collation BUT SEEMS Import was ever in swedish.

The problem "SOLVED" with : Re-create all the database with the good collation.

In fact the problem is the COLLATION SELECT FIELD FILLED WITH SWEDISH BY DEFAULT when you create a database. The solution can be that MySQL team update this with an empty select by default.

James Parsons
  • 6,097
  • 12
  • 68
  • 108
NIF
  • 462
  • 2
  • 7
  • 23