Character Set: phpmyadmin and ipad are garbled.

Character Set: phpmyadmin and ipad display are garbled characters. I created a database in the mysql management tool phpmyadmin, which contains a text field. after the database is built, I found that its attributes are: latin1_swedish_ci. is this about character sets?

Then I created a php file, in which the form can be used to write data to the database. after the file is written, I can view it in phpmyadmin. it is all garbled characters (Chinese characters are garbled and English letters are normal). However, in the program, read it out, but it is displayed normally, and Chinese characters can be displayed normally.

But I opened it on the ipad and it showed garbled characters.

How can I make it display normally in phpmyadmin? And the display on the ipad is normal? That is to say, how can we unify the php character set and the character set of fields in the database? What should I change this "latin1_swedish_ci" attribute?

Reply to discussion (solution)

Do you know what it means to end the score ???

Do you know what it means to end the score ???
Thanks for reminding me that most of them have been closed, and there are only two other ones that have no answer.

You 'd better change it to utf8_general_ci.

This is generally set to prevent garbled characters.

Database character type utf8
Utf8 utf8_unicode_ci
Use utf8 for PHP files
Mysql operation class setting utf8

It has nothing to do with the character set of your table and the character set of the page.