[SOLVED] Foreign letters stored in database like Scandinavian ä and ö

[JeditL]

Hi, I can't get PHP to display letters ä and ö that are brought from database correctly. It's fine if I just echo the letters but getting letters to show correctly from database is causing problems.

 

$str = utf8_decode($str);

 

works fine with PHP strings but not with strings from MySQL. Please help. I really should get this to work.

 

Thanks in advance.

[JonnoTheDev]

Are they stored correctly in your database? Are you using UTF-8 content-type header. Use

mysql_query("SET NAMES UTF8"); when conneting to your database.

[JeditL]

Use mysql_query("SET NAMES UTF8"); when conneting to your database.

 

Thanks, mate. That did the trick. All the letters are now shown correctly.  Cheers!