Member Avatar for benqus

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!

charset_problems.png 448.32 KB
  • 3 Contributors
  • 3 Replies
  • 203 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by benqus
Member Avatar for sam023

Its not php poblem..
try

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

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

Edited by imvivekkapoor because: n/a
Member Avatar for benqus

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 meeting, networking, learning, and sharing knowledge.