MySQL5.7 文字コード utf8mb4

[ucan-lab]

MySQL文字コード

> SHOW VARIABLES LIKE '%character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8mb4                    |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | utf8mb4                    |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

my.cnf

[mysqld]
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci

[client]
default-character-set = utf8mb4

[mysqldump]
default-character-set = utf8mb4

COLLATE

• utf8mb4_general_ci
  • 「ひらがな」「カタカナ」を区別する
• utf8mb4_unicode_ci
  • 「ひらがな」「カタカナ」を区別しないため混在する

参考資料

• https://www.slideshare.net/tmtm/mysql-62004569
• 照合順序 https://qiita.com/kazu56/items/6af85ffcf8d3954455ad