特殊字符不会以正确的方式插入到mysql表中

Question

I have a mysql database which Im trying to submit values to through a php file from a form.

If I manually insert values to the table 'myTable' with special characters like the swedish åäö letters, it works fine.

But when I am trying to use 'INSERT INTO' after a form is submitted on my page, to insert values to the table, all special characters turn out weird... Like symbols...

All collations are set to utf-8-swedish!

NOTE1: If I echo the values 'POSTED' from the form submit, the special characters are shown proberly. So its not the php file or the form itself.

NOTE2: All documents are set to utf-8

Thanks

Answer 1

Ensure with mysql_set_charset that the MySQL connection charset is UTF-8.