Solution For MySQL UTF-8 Encoded Data Unreadable In Web Pages.
Introduction
This blog entry is about technical issue regarding data manipulation in mysql, with tool like phpmyadmin. Data stored in Mysql is retrived/input with PHP pages. If you can’t understand the topic at all, please don’t continue.
Problem
I’ve been dealing with web projects for years. Mostly with PAM(php + apache + mysql) environment. When it comes to something that requires user’s interactions( comment, forum, etc), I always use UTF-8 as the default charset in web pages. This ensures that different characters(simplified chinese, traditional chinese, japanese etc)can be displayed on same page nicely without users have to change the character encoding in the browser.
Introduction
This blog entry is about technical issue regarding data manipulation in mysql, with tool like phpmyadmin. Data stored in Mysql is retrived/input with PHP pages. If you can’t understand the topic at all, please don’t continue.
Problem
I’ve been dealing with web projects for years. Mostly with PAM(php + apache + mysql) environment. When it comes to something that requires user’s interactions( comment, forum, etc), I always use UTF-8 as the default charset in web pages. This ensures that different characters(simplified chinese, traditional chinese, japanese etc)can be displayed on same page nicely without users have to change the character encoding in the browser.