upgrade mysql 4 to 5 , coding problem

[chings]

i recently upgrade mysql from 4 to 5

but i found all the chinese character in the old database changes to ???????? (question mark) in my php application

i am using UTF-8 .

could anyone help

[Bjom]

'using UTF-8' where? In the DB, HTML, PHP?

Maybe you just need to change/add this in the php.ini:

default_charset = "UTF-8"

or maybe your IDE needs it's settings adjusted?

[chings]

i tried , but fails

after i install appserv , the php MyAdmin is running well, but my other php application can't display the non-alphanumeric character properly

so what is my problem ,thks

[Bjom]

other php application

what would that be? Your description is very vague.

[mpb001]

Are you sure the database is UTF-8 and not Latin-1 with UTF-8 in it. MySql isn't that fussy and doesn't raise errors. Everything looks okay on the outside, just all the database string functions etc possibly misbehave.

If it is UTF-8 try

$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;
	query_call( $sql );   

}

After connection