CODEWITHSUNDEEP
mysqlexcelcsv
user823527
user823527

Reputation: 3712

Export csv from excel with foreign characters for import into MySQL

When I export this from Excel in a csv file to import into MySQL

Bl Michał Sopoćko, Priest

I get this

Bl Micha? Sopo?ko

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

Upvotes: 4

Views: 1539

Answers (1)

sebast26
sebast26

Reputation: 1792

First you should check the encoding option that was specified during the export from Excel (in save dialog -> Tools button -> Web options -> Encoding Tab).

Next try to convert database table to this encoding:

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

Upvotes: 1

Related Questions