I'm in phpMyAdmin. This MySQL management tool, built a database, which has a text field, built to find: Its properties are: Latin1_swedish_ci, this is the character set is it?
Then I built a PHP file, which is useful form table one-way database write action, found after writing, in phpMyAdmin, all is garbled (Chinese characters are garbled, English normal), but, in the program, read it out, it shows but normal, can display Chinese characters normally.
But I opened it with an ipad and it showed garbled characters.
How do you make it appear normal in phpMyAdmin? And it's normal in the ipad? That is, the character set of PHP, and the character set of the field in the database, how to unify? What do you need to change this "Latin1_swedish_ci" property to?
Reply to discussion (solution)
Do you know what is a knot paste to the points???
Do you know what is a knot paste to the points???
Thank you for reminding me that most of the knot has been made, and there are only two unanswered questions and so on.
Better change to Utf8_general_ci.
Usually set these places to prevent garbled
The character type of the database UTF8
The character set of the data table field UTF8 Utf8_unicode_ci
PHP files using UTF8
MySQL Operation class settings UTF8
That's okay with that. The character set of the table character set and the page