Export csv from excel with foreign characters to import into MySQL

Question

When I export it from Excel to a csv file for import into MySQL

Bl Michał Sopoćko, Priest

I get it

Bl micha? Sopho? To

Is there a way to export a file to have the correct characters?

Answer 1

First you need to check the encoding parameter that was specified during export from Excel (in the save dialog → Tools button → Web Options - Encoding tab).

Then try converting the database table to this encoding:

ALTER TABLE <table_name> CONVERT TO CHARACTER SET <character_set> COLLATE <collate_name>