Hi,
an die Codeblöcke hatte ich gar nicht gedacht...
So hier die Ausgabe des Befehls:
mysql> SHOW CREATE TABLE Pferde;
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Pferde | CREATE TABLE `Pferde` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Index` int(10) NOT NULL,
`Name` varchar(50) DEFAULT NULL,
`Rasse` varchar(50) DEFAULT NULL,
`Farbe` varchar(50) DEFAULT NULL,
`Geschlecht` varchar(50) DEFAULT NULL,
`Vater` varchar(50) DEFAULT NULL,
`Mutter` varchar(50) DEFAULT NULL,
`Stockmaß` decimal(50,2) DEFAULT NULL,
`Nachkommen` decimal(50,0) DEFAULT NULL,
`Verwendung` varchar(100) DEFAULT NULL,
`verkäuflich` tinyint(1) DEFAULT NULL,
`Herkunftsland` varchar(50) DEFAULT NULL,
`Marke` varchar(50) DEFAULT NULL,
`Bild` mediumblob,
`Geburtstag` date DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=333 DEFAULT CHARSET=utf8 |
+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> SHOW VARIABLES LIKE 'character_set_system';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| character_set_system | utf8 |
+----------------------+-------+
1 row in set (0.01 sec)
mysql> SHOW VARIABLES LIKE 'character_set_results';
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| character_set_results | utf8 |
+-----------------------+-------+
1 row in set (0.00 sec)
Was ich halt seltsam finde, das auch die Variablen "character_set_system" "character_set_results" auf utf8 stehen, laut Dokumentation http://dev.mysql.com/doc/refman/5.5/en/charset-metadata.html, sollte das jetzt eigentlich gehen.