来自mysql请求的字符串，charset问题

Question

names are stored in mysql with utf8_unicode_ci. i get the names from the db with a simple sql request and echo them in a table.

Julián echoes like Julián. Can I run the $name variable through some command to unscramble it, or modify my sql request? it's a simple SELECT name FROM table now.

Answer 1

Check the db connection string, ensure that you have specified the charset utf-8 in your connection string. And the html encoding charset should also be specified, such as follow:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />