Hello! =)

I have a big problem here, with PHP charset stuff. My mysql is utf8_hungarian_ci , but the php shows me only '?' and ?inDiamond signs. I guess the PHP's working incorrectly, because my MySQL returns my records just fine.

Any solutions? =)

Thank you!

Recommended Answers

Hi benkus,

Please change the following setting for your database:

MySQL charset : UTF-8 Unicode (utf8)
MySQL connection collation : utf8_general_ci
MySQL collation : utf8_general_ci


You can also try this : After selecting database mysql_select_db(dbname); use mysql_query('set names "utf8"');

Hope this help..

KPs

Jump to Post

All 3 Replies

Its not php poblem..
try

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

Hi benkus,

Please change the following setting for your database:

MySQL charset : UTF-8 Unicode (utf8)
MySQL connection collation : utf8_general_ci
MySQL collation : utf8_general_ci


You can also try this : After selecting database mysql_select_db(dbname); use mysql_query('set names "utf8"');

Hope this help..

KPs

Oh yea, the mysql_query("SET NAMES 'utf8'") has solved my problem, thank you! =) But the charset does not need to be switched back. Works like a charm! =)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.