MariaDB10.6 サポートされる照合順序を一覧で取得する
環境
Windows 10 home 64bit
MariaDB 10.6.4
構文
SHOW COLLATION;
サポートされる照合順序(collations)を一覧で取得します。
使用例
1.照合順序を確認します
MariaDB [(none)]> SHOW COLLATION; MariaDB [(none)]> SHOW COLLATION LIKE 'utf8%';
2.where条件を指定します
MariaDB [(none)]> SHOW COLLATION WHERE Charset='latin1'; +-------------------------+---------+------+---------+----------+---------+ | Collation | Charset | Id | Default | Compiled | Sortlen | +-------------------------+---------+------+---------+----------+---------+ | latin1_german1_ci | latin1 | 5 | | Yes | 1 | | latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 | | latin1_danish_ci | latin1 | 15 | | Yes | 1 | | latin1_german2_ci | latin1 | 31 | | Yes | 2 | | latin1_bin | latin1 | 47 | | Yes | 1 | | latin1_general_ci | latin1 | 48 | | Yes | 1 | | latin1_general_cs | latin1 | 49 | | Yes | 1 | | latin1_spanish_ci | latin1 | 94 | | Yes | 1 | | latin1_swedish_nopad_ci | latin1 | 1032 | | Yes | 1 | | latin1_nopad_bin | latin1 | 1071 | | Yes | 1 | +-------------------------+---------+------+---------+----------+---------+ 10 rows in set (0.001 sec)