Special Characters in MySQL

[Anon]

Ok,

I have a form to gather user input, which is then put in a MySQL database through PHP. Now, the input is in norwegian, and thus often contains special characters. I use phpMyAdmin to view/browse the content of my MySQL database, and phpMyAdmin (a PHP utility, doh 🙂 outputs the special characters all fine in the browser. But trying to fetch the values myself for display ends in loosing the special character and the character infront of it, like "something" becomes "somthing" where is the special character...

I have triedusing htmlspecialcharacters on the output after fetching it through mysql_fetch_array($result) to get an associative array... help!

[Anon]

Ok, hehe... 5 mins after my original post, I notice that htmlspecialchars() only convert a few selected characters, instead, using htmlentities() worked all fine... strange though, cause looking in the source of phpMyAdmin showed me that they used htmlspecialchars... oh well, I might have overlooked something there too...

Hope others can find this useful too!