[SOLVED] Table Charset utf8_unicode_ci and CSS set to utf-8, I'm unable to show "åäö

[Bisa]

My tables are set as utf8_unicode_ci and the css says utf-8, when I fetch data from the db to show on my website I am unable to show characters like å, ä and ö unless I convert them to å ä and ö before inserting them into the database.

 

I suspect I miss something newbish here but then again I am a newb  :-\

 

I'd appreciate any pointers to help me out here, thnx in advance =)

[Bisa]

never mind, seems the "universal" charset is not as universal as I thought it was 

 

changing utf-8 to iso-8859-1 did the trick and all of my å, ä and ö are rendered correctly in my browser.

[germinal]

thx for the solution... have been looking for this for a while

[Mchl]

You should do

 

SET NAMES = 'utf-8'

 

query, each time you connect from PHP to MySQL