mysql and arabic

[kooshin.com]

hello guys i need your help.

How can mysql display Arabic well. Right now it is displaying them as ??????? . I'm using mambo and everyting is working fine on the local server but when online all i see is question marks .

here is the server info

Server version: 4.1.21-standard
Protocol version: 10
Server: Localhost via UNIX socket
User: islamic@localhost
MySQL charset: UTF-8 Unicode (utf8)


the local server of the mysql is MySQL 4.0.24-nt .


how can i fix this problem?

Thanks in advance.

[champ]

It might be a 'AddDefaultCharset' apache problem. You may need to turn that setting off.

If I were a bettin' man, I'd say the problem is with mysql. Although your DB variables may all be correctly set to utf8 (connections and all), you may still get the question marks.

Try this...
Before all your DB queries, send this query first:

mysql_query("SET NAMES 'utf8'") 

If that solves it, you either need to do the above before executing any of your real queries.

If you have access to your mysql config file (my.cnf) then you can avoid the hassle above by adding the following to the [mysqld] section:

[mysqld]
init_connect="SET NAMES utf8"

Also, make sure the following variables are properly set:

[client]
default-character-set=utf8

[mysqld]
default-character-set=utf8

Keep in mind that the my.cnf fix does not work it your script is connecting to mysql using the 'root' account.

[kooshin.com]

hi there, thanks for the answer and the detailed info. I will do that and let you know the result. Thanks again.