Umlauts and special characters are not displayed in 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?

http://httpd.apache.org/docs/2.2/mod/core.html#AddDefaultCharset — Aleksei Matiushkin, Nov 24 '14 at 18:37
http://stackoverflow.com/questions/10367133/utf-8-showing-correctly-in-database-however-not-in-html-despite-utf-8-charset?rq=1 — Sebas, Nov 24 '14 at 18:38

score 1 · Accepted Answer · answered Nov 24 '14 at 19:23

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" />

answered Nov 24 '14 at 19:23

Navarr

3,703
7
33
57

i did these steps, but it didn't help :/ – progNewbie Nov 24 '14 at 23:38
@progNewFag If using utf8_decode() fixed your problem than it's because your page isn't being interpreted in UTF-8 (or some step between your database and output isn't UTF-8; as utf8_decode transform UTF into ISO-8859-1. – Navarr Nov 26 '14 at 02:44
so how can i fix this? Where lies the mistake that the page isn't interpreted in UTF-8? – progNewbie Nov 26 '14 at 20:54
@progNewFag without seeing the page there's not much I can help you with. You should double check the content-type header and make sure you have the charset=utf-8 tag – Navarr Nov 27 '14 at 00:30

score 0 · Answer 2 · answered Nov 24 '14 at 18:37

0

This sounds like an issue with character encoding, you need to use utf-8. I think the default is ascII. I only write pages in English but this guy has all of the steps needed.

answered Nov 24 '14 at 18:37

Useless Intern

1,294
1
10
20

score 0 · Answer 3 · answered Nov 24 '14 at 19:36

0

You can convert the file to UTF8 using notepad plus plus. Try it.

answered Nov 24 '14 at 19:36

Flavio Vinho

23
6

Umlauts and special characters are not displayed in php mysql

3 Answers3