hope this help you
http://forums.mysql.com/read.php?103...7609#msg-97609

thanks faith but that didnt help with my problem.

:/

did you try ansi_unicode_?

i have something like this
i insert data into db
in the db the data is not readable
but when select it on a php page
everything goes well
so the application is running anyway

is it local or remote located database?
if locale chech my.ini, find default charset and change it to ansi_unicode
collation in the same way.

Got it working!

mysql_query("set names 'utf8'");

Thanks everyone for your replies..

I Have same problem...
It is solved also when I put
mysql_query(

To read ,write and sort Arabic text in mysql database using php correctly, make sure that:

1- MySQL charset: UTF-8 Unicode (utf8)
2- MySQL connection collation: utf8_general_ci
3- your database and table collations are set to: utf8_general_ci or utf8_unicode_ci

Then, add this code in your php script when you connect to db:

mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');

for more details:
http://www.adviesenzo.nl/examples/ph...l_charset_fix/

I have tested it and it works well, I hope that would be helpful..

thanks!

hey i was have this problem for two days and i have found the solution .. you have to add this code
accept-charset="utf-8"
to your forum