Question: How to deal with non ASCII characters (German letters)

[Mysterio]

I am working in a website containing German language, and there is many data to store in database (MySQL).

They gave me a database dump which I imported; but there are some German letters like "ä, ö, ü" stored in LONGTEXT fields and I am not being able to display them correctly.
Any suggestion?

Thank you!

[pichiriche]

add after line sql connect this

mysql_query('SET NAMES \'utf8\'');

and make tables in phpmyadmin character utf-8

[something else]

header("Content-type: text/html; charset=latin1");

ALTER TABLE `table` DEFAULT CHARACTER SET=latin1;

[Mysterio]

Thank you guys! Will try both cases and tell you!

[something else]

as far as im aware utf8 doesnt support ä, ö, ü etc

[GumSlone]

as far as im aware utf8 doesnt support ä, ö, ü etc

utf supports öäü and cyrillic and other symbols too.
Unicode/UTF-8-character table
if you make a site which should support multilanguage symbols, you have to set utf-8 enconding for your mysql tables.

[Mysterio]

It was not helping to change encoding of the table fields, until I switched to "Content-type: text/html; charset=latin1"

This seems to be a solution!

Thank you!

[CreativityKills]

It was not helping to change encoding of the table fields, until I switched to "Content-type: text/html; charset=latin1"

This seems to be a solution!

Thank you!

when u change mysql charset also change page charset too.

[Mysterio]

Yes, thanks!

I was getting confuse because UTF-8 or UTF-16 was not working, while latin1 did the job without touching database!
That was my aim.

[metulj]

Yes, thanks!

I was getting confuse because UTF-8 or UTF-16 was not working, while latin1 did the job without touching database!
That was my aim.

well... UTF-8 should work as well
and it would be more appropriate
for special chars like ä, ö, ü etc,
also chars like č, ć, đ, š, ž, etc
it just take a bit more time to figure it out

[CreativityKills]

That what i was tryna say. Just cuz latin worked dnt mean its ok.