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.