Re: Umlaute mit Mysql und PHP

[Frank Habermann <lordlamer@lordlamer.de>]

Hier bei mir:

<log>
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 557046
Server version: 5.0.32-Debian_7etch1 Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table kunden ( name varchar(10) NOT NULL UNIQUE ) engine 
MyISAM DEFAULT CHARSET utf8;
Query OK, 0 rows affected (0.03 sec)

mysql> insert into kunden values ("Müller");
Query OK, 1 row affected (0.00 sec)

mysql> insert into kunden values ("Muller");
ERROR 1062 (23000): Duplicate entry 'Muller' for key 1
mysql> select name from kunden;
+--------+
| name   |
+--------+
| Müller |
+--------+
1 row in set (0.00 sec)

mysql>

</log>