Mysql character encoding fail

Asked Jul 23 '14 at 14:57

Active Jul 23 '14 at 14:57

Viewed 17 times

I have a large table (~17k rows) in a mysql database. Some of the fields in the table should contain the swedish characters "åäö", but right now it contains characters like "Ã¤" instead of "ä". How can I fix all my data so the characters will be correct? The character set of the table is already utf-8, and if I update a field in the table manually I am able to enter åäö.

How can I fix all fields (wont be able to do it manually since it is ~17k rows)?

asked Jul 23 '14 at 14:57

AlexanderNajafi

1,631
2
25
39

Also see http://stackoverflow.com/questions/279170/utf-8-all-the-way-through – deceze Jul 23 '14 at 15:00
Try `iconv("ISO-8859-1", "UTF-8", $field)`. http://php.net/manual/en/function.iconv.php – Aleksei Matiushkin Jul 23 '14 at 15:01

Mysql character encoding fail

0 Answers0