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 Chinese characters.
As the screenshot below, I think the problem came from the character_set_server, which is set to latin1.
Is there any way I can change it to utf8? I really want to make sure words can be stored properly.
Where did you see this? Please note that phpMyAdmin is known to have problems with special characters. So if you write data from your own code and retrieve it through your own code, it works perfectly. But in phpMyAdmin it’s all garbled.
I don’t quite know why this happens, but it shouldn’t prevent the use of special characters on your website