Japanese text is unrecognizable in phpMyAdmin?

Question

I am phpMyAdmin, why is Japanese text in tables unrecognizable? However, I can output the Japanese text from the tables and it can be displayed correctly. Any idea? How to fix phpMyAdmin?

Answer 1

Most likely you have wrongly set encoding in table structure and phpMyAdmin uses this information. What encoding you see configured for columns in table structure?

MySQL documentation on this topic might help you to fix this.