MySQL 文字セットの照合順序を一覧表示する
構文
show collation;
照合順序とは、文字の大小関係、ソート順を表します。
使用例
MariaDB [testphp]> show collation;
+------------------------------+----------+-----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+------------------------------+----------+-----+---------+----------+---------+
(中略)
| utf8mb4_general_ci | utf8mb4 | 45 | Yes | Yes | 1 |
| utf8mb4_bin | utf8mb4 | 46 | | Yes | 1
MariaDB [testphp]> show collation;
+------------------------------+----------+-----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+------------------------------+----------+-----+---------+----------+---------+
(中略)
| utf8mb4_general_ci | utf8mb4 | 45 | Yes | Yes | 1 |
| utf8mb4_bin | utf8mb4 | 46 | | Yes | 1
MariaDB [testphp]> show collation; +------------------------------+----------+-----+---------+----------+---------+ | Collation | Charset | Id | Default | Compiled | Sortlen | +------------------------------+----------+-----+---------+----------+---------+ (中略) | utf8mb4_general_ci | utf8mb4 | 45 | Yes | Yes | 1 | | utf8mb4_bin | utf8mb4 | 46 | | Yes | 1
説明
utf8mb4_general_ci 英字の大文字と小文字を区別しない
utf8mb4_bin 英字の大文字と小文字を区別する