I have a website that has some Chinese characters in it. When I exported the MySQL database backup, everything shows up as garbage. From what I've read online, it's because the original encoding was set as 'latin1' when I'm supposed to use 'utf8'. However, on the front end (Like accessed from web browser), the text on the site shows up just fine.
Is there any way I can fix the MySQL database backup to show Chinese characters properly instead of garbage?
Question
chconline Veteran
I have a website that has some Chinese characters in it. When I exported the MySQL database backup, everything shows up as garbage. From what I've read online, it's because the original encoding was set as 'latin1' when I'm supposed to use 'utf8'. However, on the front end (Like accessed from web browser), the text on the site shows up just fine.
Is there any way I can fix the MySQL database backup to show Chinese characters properly instead of garbage?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts