开发者

UTF-8 encoding issues with database and displaying on webpage

开发者 https://www.devze.com 2023-02-16 20:13 出处:网络
I have th开发者_Python百科e following character ó stored in a VARCHAR column on a MySQL database. The collation for this column is utf8_general_ci

I have th开发者_Python百科e following character ó stored in a VARCHAR column on a MySQL database. The collation for this column is utf8_general_ci

On the webpage I have the following meta tag:

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

Yet when the data is pulled out and displayed it show as: �

But ONLY on my Mac.

If I had mysql_query("SET NAMES 'UTF8'"); then it displays properly on my Mac.

On my PC it displays properly, but when I add mysql_query("SET NAMES 'UTF8'"); it displays incorrectly.

What am I missing?


There are lots of things that could be causing this, and the web browsers you have tried might try to be helpful in different ways or have different defaults.

Judging from MySQL manual 9.1.10. Unicode Support, SET NAMES 'UTF8' should be used if you want UTF-8 output from MySQL.

Your content-type looks a bit strange, is it a typo? It should probably be:

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

I'd start by using a network sniffer (for example TCPView or Wireshark) or some other means to verify that the output from the server really is UTF-8, i.e. that the ó is sent from the server as 0xC3 0xB3. If that is ok, check for problems with Content-type settings.

0

精彩评论

暂无评论...
验证码 换一张
取 消