MySQL 字段内容区分大小写
mysql> SHOW COLLATION like 'utf8%';+--------------------------+---------+-----+---------+----------+---------+
| Collation | Charset | Id| Default | Compiled | Sortlen |
+--------------------------+---------+-----+---------+----------+---------+
| utf8_general_ci | utf8 |33 | Yes | Yes | 1 |
| utf8_bin | utf8 |83 | | Yes | 1 |
| utf8_unicode_ci | utf8 | 192 | | Yes | 8 |
...
| utf8mb4_general_ci | utf8mb4 |45 | Yes | Yes | 1 |
| utf8mb4_bin | utf8mb4 |46 | | Yes | 1 |
| utf8mb4_unicode_ci | utf8mb4 | 224 | | Yes | 8 |
| utf8mb4_icelandic_ci | utf8mb4 | 225 | | Yes | 8 |
页:
[1]