when i query in phpmyadmin
like
insert into table('نچجاعجان');
it display correctly but when i try to insert by php page it displays in the field like this:
ÙØ§Ù†Ù†Ù†Ø§Ùنعن
My table collation is utf8 general ci and my column collation is also utf8 general ci. What am i doing wrong?
ok, you also need to set the character set from your code connection side. this can be done with:
mysql_query("set character_set_server='utf8'");
mysql_query("set names 'utf8'");
Although I would strongly recommend you dont use mysql_* functions as they are deprecated and you are putting a limited lifespan on your code. Its seriously worth looking at moving to mysqli_* functions - the learning curve is quite easy and it will open up a whole new world of coding possibilities for you ;)