Character Set Encoding in a Table I have the following data:Trollhättan


If I print out and setting up the header to utf-8, then this is the output in the browser.
If I'm not setting up the utf-8 in the header, TrollhÃ¤ttan. However,when I'm storing the data in the database and checking through phpmyadmin, I am getting the following string : TrollhÃƒÂ¤ttan.
When I am setting up the header to utf-8, I'm getting this string : TrollhÃ¤ttan beside this Trollhättan. 


Since the table is latin1_swedish_ci, do I have to use in the table UTF-8?
You need to make sure that when you are "storing the data in the database", the client you use is using utf8. Then setting the http header to utf8 completes the round trip.

The surprise is that it doesn't matter much what character set is used in the database (although it might well be convenient for that to be utf8 too).