MariaDB10.6 サポートされる照合順序を一覧で取得する

2022年11月20日

環境
Windows 10 home 64bit
MariaDB 10.6.4

構文
SHOW COLLATION;
サポートされる照合順序（collations）を一覧で取得します。

使用例
1.照合順序を確認します

MariaDB [(none)]> SHOW COLLATION;

MariaDB [(none)]> SHOW COLLATION LIKE 'utf8%';

MariaDB [(none)]> SHOW COLLATION; MariaDB [(none)]> SHOW COLLATION LIKE 'utf8%';

MariaDB [(none)]> SHOW COLLATION;
MariaDB [(none)]> SHOW COLLATION LIKE 'utf8%';

2.where条件を指定します

MariaDB [(none)]> SHOW COLLATION WHERE Charset='latin1';

+-------------------------+---------+------+---------+----------+---------+

+-------------------------+---------+------+---------+----------+---------+

| 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)

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)

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)

MariaDB

Posted by arkgame

関連投稿: