絵文字を含むストリングを挿入時に次のエラーがでました。
Incorrect string value: '\xF0\x9F\x98\x8A^M...'
その時の文字コード
> show variables like "chara%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb3 |
| character_set_connection | utf8mb3 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb3 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
設定の変更
/etc/mysql/mariadb.conf.d/50-client.cnf
[client]
#
#
default-character-set = utf8mb4
MariaDB を再起動
sudo systemctl restart mariadb
設定が変更されたことを確認
> show variables like "chara%";
+--------------------------+----------------------------+
| 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 | utf8mb3 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
絵文字を含むストリングを挿入できることを確認。