在php mysql中不显示变音符号和特殊字符

Question

I have written a small social network on my pc in my localhost xampp. Here everything works fine.

Text in my mySQL Database looks like this: "was für pizza?" instead of "was für Pizza?". This is fine, it is displayed like "was für Pizza?" in my localhost on my PC.

But now I uploaded it to my Webspace and there I got this "was für pizza?" displayed.

Can anyone help me?

Answer 1

Some steps:

• Make sure your table/columns are set to a unicode collation. An older, but still good one is utf8_unicode_ci. It works for most cases, but if you're going to have emoji (which you might with a social network) you'll want to use utf8mb4_unicode_ci.
• Make sure that PHP's connection with the database is UTF8. This is generally accomplished by running the query SET names 'utf8'
• Make sure your website is telling the browser that it's UTF8. This is generally accomplished by sending the Content-Type: text/html;charset=utf-8 header, by including a meta tag that says the same thing, <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> or by including a meta-charset tag (newer) <meta charset="utf-8" />