Storing swedish characters in mysql database
collation, mysql, utf-8
Solution
Call
mysql_set_charset("utf8");
After connecting and before making any queries.
Your database charset is just for storage, not for transmission between app and database.
Problem
I'm having problems storing Swedish characters in my MySQL database. I want to store them in my table called `users` with the collation utf8-bin. Even though I'm using utf8, the characters `å ä ö` gets stored as `Ã¥ ä ö` and I don't know why. Retrieving the data and echoing it gives me the same output, with the weird characters instead of `å ä ö`. Any help is appreciated.