I have a strange problem with some documents on my webpage.
My data is stored in a MYSQL Database, UTF8 encoded. If read the values my webbpage displays
Rezept : Gemï¿½se mal anders (Gemï¿½selaibchen)
I need Ã¼ / Ã¼!
Content in the database is "GemÃ¼se ... " ..
The raw data in my error_log looks like this
[title] => Rezept : GemÃ¼se mal anders (GemÃ¼selaibchen)
The webpage header is:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <!--[if IE]> <link rel="stylesheet" href="http://www.dev-twitter-gewitter.com/css//blueprint/ie.css" type="text/css" media="screen, projection"> <![endif]--> <meta name="text/html; charset=UTF-8" content="Content-Type" />
MySQL needs to know you want the output as UTF-8 - it's likely configured to send as latin1, so your browser sees the invalid UTF-8 byte sequences and outputs the "not a character" glyph.
Send the query "SET NAMES utf8" immediately after opening the MySQL connection, or change the configuration (if possible).
The content is written by members of the stackoverflow.com community.
It is licensed under cc-wiki