arabic character inserting to MySQL database

[faruk_34]

Hi,
i am facing problem incase of inserting and viewing arabic characater to mysql database using php. i changed the tabel character set to utf8 and also in php.ini default character set is changed to UTF-8.but i am getting error as ??? while retrieving. so can anyone help to solve this problem?

Regards,
faruk chowdhury

[halojoy]

hi faruk

there are these involved:

Script ( php html code )
Browser ( firefox, iexplorer )
Server ( apache, etc )
PHP ( php.ini )
MySQL

You have changed in php.ini.
This setting is used if no charset is set in php script.
You have changed in MySQL, table=utf-8
But you have some old data in db-table?
I dont know if old data is rewritten, when changing charset of a table.

Running phpinfo() shows this about my HTTP Headers Information:

Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Content-Type text/html; charset=ISO-8859-1

[mpb001]

Also you may need to set the client connection details to utf-8 via a query at the start of the connection of the my.ini/my.cnf.

Do a SHOW VARIABLES query in php and dump the output. It can try and do magic if not properly set.

Manual method via php.

    $set_connection_encodings = array(
                'character_set_client=utf8'
                ,'character_set_connection=utf8'
                ,'character_set_results=utf8'
                ,'collation_connection=utf8_general_ci'
                ,'collation_database=utf8_general_ci'
        );

        foreach( $set_connection_encodings AS $set_connection_encoding )
        {
            $sql = 'SET ' . $set_connection_encoding;
            mysql_query( $sql );   
        }