[MySQL] sensiblité aux accents

Seulement avec latin1.

mysql> create table tn15 (s1 char(15) character set latin1 collate
latin1_general_ci);
Query OK, 0 rows affected (0.07 sec)

mysql> insert into tn15 values ('ò'),('o'),('Ò'),('O');
Query OK, 4 rows affected (0.05 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> select * from tn15 where s1 = 'o';
+------+
| s1 |
+------+
| o |
| O |
+------+
2 rows in set (0.15 sec)

mysql> select * from tn15 where s1 = 'ò';
+------+
| s1 |
+------+
| ò |
| Ò |
+------+
2 rows in set (0.00 sec)

Peter Gulutzan
MySQL AB