MySQL Workbench encoding errors when importing from csv

31 Views Asked by At

I'm trying to use a csv file (utf-8) to insert some data in a table (utf8mb3, tryed also with utf8mb4). The thing is:

There is a csv line that looks like this:

8,raikkonen,7.0,RAI,Kimi,Räikkönen,1979-10-17,Finnish,http://en.wikipedia.org/wiki/Kimi_R%C3%A4ikk%C3%B6nen

But looks like this when inserted into the database:

'8', 'raikkonen', '7', 'RAI', 'Kimi', 'Räikkönen', '1979-10-17', 'Finnish', 'http://en.wikipedia.org/wiki/Kimi_R%C3%A4ikk%C3%B6nen'

As you can see, there are some encoding errors once data is inserted.

I`ve tryed to solve it using several types of enconding in MySQL workbench, but nothing worked. Any idea? Thanks.

0

There are 0 best solutions below