mysql> insert into umlauttest values (1, 'Vögel');
Query OK, 1 row affected, 1 warning (0.00 sec)
mysql> show warnings;
+---------+------+--------------------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------------------+
| Warning | 1366 | Incorrect string value: '\x94gel' for column 'term' at row 1 |
+---------+------+--------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from umlauttest;
+----+------+
| ID | term |
+----+------+
| 1 | V |
+----+------+
1 row in set (0.00 sec)
Partager