![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2023-07-07 (金) 11:16:26
参考：MariaDB(MySQL)の文字コードを設定（変更）する
# mysql -u root -p
root@localhost [(none)]> show variables like "character%";
| Variable_name | Value |
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
8 rows in set (0.026 sec)
root@localhost [(none)]> show variables like "collation%";
| Variable_name | Value |
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
3 rows in set (0.001 sec)
/usr/local/etc/mysql/conf.d/MariaDB_Charactor_Set.cnf
[mysqld] character-set-server=utf8mb4 [client] default-character-set=utf8mb4
"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/local/share/mysql/charsets/ |
8 rows in set (0.001 sec)
"collation%";
| Variable_name | Value |
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
3 rows in set (0.001 sec)
Total access 267：本日 1：昨日 0
