inserting arabic characters into mysql

[roy--]

Hello,

I have looked everywhere on the web for a solution to this problem.

I am trying to store arabic characters into mysql via an html form.

i have set the meta charset to utf-8 and have tried mysql_query('set names 'utf=8'")

but still i get garbled characters in my table:

لربيلبي

Please advise!

[fatihpiristine]

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

[roy--]

thanks faith but that didnt help with my problem.

:/

[fatihpiristine]

did you try ansi_unicode_?

[w_3rabi]

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

[fatihpiristine]

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.

[roy--]

Got it working!

mysql_query("set names 'utf8'");

Thanks everyone for your replies..

[Lotus-Sy]

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

[almounkez]

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/php_mysql_charset_fix/

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

thanks!

[wafa@]

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