imported database has special chars encoded as 'Ã©' instead of 'é'
Posted on 2006-11-14
I have an export from a mysql database from an other company.
This is a textfile with create and insert statements.
CREATE DATABASE `dbname` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
INSERT INTO `comments` VALUES (272, 'firstname.lastname@example.org', 'How much does this cost and is it also available in BelgiÃ«?');
(this is translated from dutch)
The last word here should be "België" not "BelgiÃ«".
1. Is there anything I can do to fix this at import.
2. Or should the other company have done something else while exporting?
2.1 And what do I need to tell them to get the data in the right format?