UTF-8 character encoding problem
Hello,
I run an online forum which uses MySQL 4.1.21 database. At the time of installation, the database was in latin1_swedish_ci bu default. Later, users began to put UTF-8 encoded characters in the forum.
The problem is, when I dump and restore the database using phpMyAdmin, all UTF-8 encoded texts become garbage. So again I used phpMyAdmin to alter the database, its tables and necessary fields to utf8_general_ci collation. But no luck!
I need to change my hosting. How can I dump & restore the database correctly? I don't have much idea on mySql operations so a bit detailed guide will be helpful.
Thanks in advance for your kind help (I need it badly, please).
Subject
Views
Written By
Posted
UTF-8 character encoding problem
2772
July 01, 2007 06:15PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.