My website has a form that will insert data to the table once the submit is send.
From what I saw, the data does receive but words can be garbled if it contains Japanese characters.
Is there any way I can change it to utf8?
I try set global character_set_server = (utf8mb4);,but there is an error because of authority.
You can’t set the global server character set, because that’s a system wide property. You could try setting it for just the connection though, by using that statement without the global word.
However, you will probably want to set the MySQL charset through the PHP connection code instead, because I’m not sure that setting it with the SQL statement works.
This article has more information about why this issue happens, and how to fix it:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.