从mysql 5.5降级到5.1，utf-8 general_ci

Question

i am using wamp for localhost, its mysql version is 5.5. After i finished my website i wanted to upload it to my website (shared hosting). which runs (5.1) but i cant insert arabic letters anymore.

when i insert any field in arabic, it gets stored as weird characters "ضووع".

it was doing great on my pc, but not online.

the database is myisam by default, but all tables are innodb with utf8_general_ci. also this is the same database i used on my machine (innodb by default) (I've imported it into my new database on the shared hosting).

so far i tried those things after making the connection

mysql_set_charset('utf8');

and

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_unicode_ci'");

what can i do more?

Answer 1

this happened to me once, i was using htmlentities() , but when i used htmlspecialchars($string, ENT_QUOTES, 'UTF-8'); the problem solved.

hope you have the same problem.