-1

on my database I've properly set up the Collation to utf8_general_ci in the case for the Japanese Characters may insert into the table. but when I tried to insert a Japanese character and viewing the table data in my phpMyAdmin database, It posted like this characters--> ベッドメイク(客室清掃)ã®ãŠä»•äº‹

How can I setup the phpMyAdmin to display the right Japanese characters?

on my HTML page I set up like this <meta charset="utf-8"> em I wrong?

Maru
  • 13
  • 1
  • 1
  • 5
  • How are you viewing the database? In your Browser? Does the data show correctly in your web page? – Oliver Jan Krylow Dec 14 '17 at 08:38
  • Don't think Collation is something magical. It's just the algorithm used when sorting. Nothing else. – Amarnasan Dec 14 '17 at 08:46
  • You enter the data through a PHP app and then try to view it in phpMyAdmin? Or you're entering it through phpMyAdmin and it displays incorrectly in phpMyAdmin? – deceze Dec 14 '17 at 08:51
  • I know you are looking for a straight answer, but if you really are into online programming, this article is a must: https://www.joelonsoftware.com/2003/10/08/the-absolute-minimum-every-software-developer-absolutely-positively-must-know-about-unicode-and-character-sets-no-excuses/ – Amarnasan Dec 14 '17 at 08:51
  • @Amit Gupta :) please scan this prob – Maru Dec 15 '17 at 07:21

1 Answers1

-3

In doc of mysql: https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html Indicate that Japanese, Chinese and Corean have an own character set.

I hope that solved your problem.

sk11z00
  • 124
  • 1
  • 6
  • Not that that's necessary. `utf8mb4` will do just fine and should be the preferred encoding anyway, unless you have some really specific reasons to use something else. – deceze Dec 14 '17 at 08:52