Re: UTF8 : LIKE does not support character expansion ?

[Peter Gulutzan]

The problem with 'Constanţa' is not as similar as it may appear, since there is no character expansion. Anyway, here's an example.

mysql> create table t56 (s1 char(10) character set utf8);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t56 values ('Constanţa');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t56 where s1 like '%nta%';
+------------+
| s1 |
+------------+
| Constanţa |
+------------+
1 row in set (0.01 sec)


My MySQL version is 5.1.12.