3 messages in com.mysql.lists.mysql-deSOS - Deutsche-Umlaute und UTF8
FromSent OnAttachments
Musa14 Oct 2006 19:14 
ha...@clansphere.de14 Oct 2006 21:19 
Jamaica-Man15 Oct 2006 00:44 
Subject:SOS - Deutsche-Umlaute und UTF8
From:Musa (BMu@web.de)
Date:10/14/2006 07:14:20 PM
List:com.mysql.lists.mysql-de

Hallo Liste,

ich kriege es einfach nicht hin, die deutschen umlaute meiner daten aus der
MySQL datenbank mit php richtig darstellen zu lassen.

meine einstellungen in MySQL: mysql> SHOW VARIABLES LIKE '%character_set%'; +--------------------------+--------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:\xampp\mysql\share\charsets\ | +--------------------------+--------------------------------+ 7 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE '%collation_%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-------------------+ 3 rows in set (0.01 sec)

mysql> SHOW GLOBAL VARIABLES LIKE '%character_set%'; +--------------------------+--------------------------------+ | Variable_name | Value | +--------------------------+--------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | D:\xampp\mysql\share\charsets\ | +--------------------------+--------------------------------+ 7 rows in set (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE '%collation_%'; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-----------------+ 3 rows in set (0.02 sec)

PHP db_connect script: mysql_connect($host, $benutzer, $kennwort); mysql_select_db($datenbank); mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET 'utf8'");

html codierung in index.php: <head> ... <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> ... </head>

anschliessend lasse ich die daten mit while und mysql_fetch_assoc ausgeben.

aber wie gesagt, die deutschen umlaute werden nicht richtig dargestellt! wenn ich die daten allerdings direkt in MySQL ausgeben lasse (konsole), werden
sie richtig dargestellt. ich würde mich wirklich sehr freuen, wenn mir einer weiterhelfen könnte!

Musa

--------------------------------------------------------------------------------