HTML / MYSQL Character Display

Question

I display a cell value from a MYSQL-Table in a PHP/HTML-Website.

I'm from Switzerland, we use special-letters like " Ö ö Ä ä Ü ü "

Usually, these letters work when they are in direct html like <p> Zurück </p>.

But when they come from mysqli-query it looks like <p>^Zur-(Salino-shape with ? inside)-ck <p>

Why is this?

Here are my settings:

table-row :

type: text ; collation : utf32-german-ci ; Null: No; Auto-Increment: No;

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

i also tried to Switch row and html to different charsets but it doesnt change.

Check the charset in php, you need to make sure php, mysql and html have matching charsets — aurbano, Jan 07 '14 at 19:14
possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Marcus Adams, Jan 07 '14 at 19:16

score 0 · Accepted Answer · answered Jan 07 '14 at 19:17

0

Set charset as utf8

mysql_set_charset('utf8');

and

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

answered Jan 07 '14 at 19:17

Rakesh KR

why not 32.. utf32 has more characters ..hasnt it? – HKK Jan 07 '14 at 19:40
Solution works perfect. But i really. Thank you very much :) would like use 32.. – HKK Jan 07 '14 at 19:43

1 Answers1