[SOLVED] multilanguage problem

[mursalat]

how do i represent non-english character from the database? i am using mysql, so say when i want to show some chinese characters "你好世界" (hello world, translated using babel fish ) from the database i get '????' signs, so how do i show it? in the database its stored perfectly (saw it using phpmyadmin.)

 

I tried including a file that contains the chinese characters, and it comes out fine.

 

so its gotta be some error in the process of getting data from the database.

[ranjuvs]

which database r u using?

[Adam]

What character set are you using for your HTML page?

 

I'm not 100% but I think using:

 

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

 

... should solve the problem. That's the universal character set so should support about anything, I think?

 

Adam

[mursalat]

@adam - I tried it already and it didn't work,

 

i am using mysql database.

[mursalat]

i tried this print_r(mysql_client_encoding());

and the result was latin1, so how do i change this client encoding?

[mursalat]

please someone - i really need help in this!

[mursalat]

first time i see a php freak getting stuck with a with question's answer

[xylex]

Make sure you set the character coding of the table you're storing the info is as UTF8 as well.

 

CREATE TABLE....DEFAULT CHARSET = utf8;

[mursalat]

i did that already.

[xylex]

Have you tried mysql_set_charset()?  Also, if you're doing any string manipulation functions with PHP after you retrieve the data, a lot of them aren't unicode compatible. 

[mursalat]

mysql_set_charset() was the solution... sorry to not answer, i did mysql_set_charset('utf8') - and it worked!