MySQL utf8_unicode_ci 利用時のソート順 table:user [name] 123456 23456 SELECT * FROM user ORDER BY name COLLATE utf8_unicode_ci ASC; 123456 23456 123456 23456

utf8_unicode_ci


mysql> SET NAMES utf8 COLLATE utf8_unicode_ci;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT ''='123';
+-------------------+
| ''='123' |
+-------------------+
| 1 |
+-------------------+


'23456' ''

utf8_unicode_ci utf8_bin


mysql> SELECT * FROM user ORDER BY name COLLATE utf8_unicode_ci ASC, name COLLATE utf8_bin;
+--------------------+
| name |
+--------------------+
| 123456 |
| |
| 23456 |
| |
+--------------------+