inserting arabic characters into mysql
 

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!

Re: inserting arabic characters into mysql
 

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

Re: inserting arabic characters into mysql
 

thanks faith but that didnt help with my problem.

:/

Re: inserting arabic characters into mysql
 

did you try ansi_unicode_?

Re: inserting arabic characters into mysql
 

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

Re: inserting arabic characters into mysql
 

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.

Re: inserting arabic characters into mysql
 

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(