Displaying UTF-8-encoded strings from MySQL with PHP [message #174508] |
Wed, 15 June 2011 10:18 |
Luke
Messages: 10 Registered: June 2011
Karma:
|
Junior Member |
|
|
Hi there,
I'm trying to migrate my project from ISO-8859-1 (Western Europe) to
UTF-8. I *can* write special characters as regular text in my php-
files, I can use special characters in echo-statements and I can even
use special characters in .ini-files, load them, and display them. But
when I load Strings with special characters from MySQL and display
them, the string's "broken".
I've tried many things: First of all, I use
<?xml version="1.0" encoding="utf-8" ?>
and
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
in the markup. In the database I tried to set my table's collation to
"utf8_general_ci". Also I tried the following functions:
mysql_query("SET NAMES ‘utf8′");
mysql_set_charset('utf8');
mb_internal_encoding("UTF-8");
all not at the very beginning of my script, but before I queried the
database and before I printed the results. I still keep getting
'wierd' characters.
Does anyone have an idea what I can do?
Thanks,
Lukas
|
|
|