0

Inserting from MySQL commands prompt is working with Japanese character.

But when I tried from phpmyadmin tool just prompt invalid character.

So I think it is phpmyadmin problem so I try to change phpmyadmin encoding setting but still not working.

Inserted Japanese character data from command prompt is show perfectly in phpmyadmin.

Please advise me

Jack jdeoel
  • 4,554
  • 5
  • 26
  • 52
  • Show a sql test case including the character? Do other characters fail to insert? What is the phpmyadmin connection character set ([ref](https://stackoverflow.com/questions/4773488/change-default-charset))? – danblack Aug 03 '20 at 03:36
  • Do you have `CHARACTER SET utf8` (or `utf8mb4`). What are the connection parameters? – Rick James Aug 04 '20 at 01:18
  • If you have a specific symptom, consult https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James Aug 05 '20 at 20:09

0 Answers0