MariaDB Charactor set
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*MariaDB Charactor set [#l380181d]
参考：[[MariaDB(MySQL)の文字コードを設定（変更）する:http...
# mysql -u root -p
root@localhost [(none)]> show variables like "character%";
|LEFT: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/chars...
8 rows in set (0.026 sec)
root@localhost [(none)]> show variables like "collation%";
| Variable_name | Value |h
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
3 rows in set (0.001 sec)
**設定ファイル作成・設置 [#q5f76adf]
/usr/local/etc/mysql/conf.d/MariaDB_Charactor_Set.cnf
[mysqld]
character-set-server=utf8mb4
[client]
default-character-set=utf8mb4
**設定後 [#gaa39141]
"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/chars...
8 rows in set (0.001 sec)
"collation%";
| Variable_name | Value |h
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
3 rows in set (0.001 sec)
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
終了行:
CONTENTS
#contents
----
Lastmodified &lastmod;
----
*MariaDB Charactor set [#l380181d]
参考：[[MariaDB(MySQL)の文字コードを設定（変更）する:http...
# mysql -u root -p
root@localhost [(none)]> show variables like "character%";
|LEFT: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/chars...
8 rows in set (0.026 sec)
root@localhost [(none)]> show variables like "collation%";
| Variable_name | Value |h
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
3 rows in set (0.001 sec)
**設定ファイル作成・設置 [#q5f76adf]
/usr/local/etc/mysql/conf.d/MariaDB_Charactor_Set.cnf
[mysqld]
character-set-server=utf8mb4
[client]
default-character-set=utf8mb4
**設定後 [#gaa39141]
"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/chars...
8 rows in set (0.001 sec)
"collation%";
| Variable_name | Value |h
| collation_connection | utf8mb4_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
3 rows in set (0.001 sec)
----
Total access &counter(total);：本日 &counter(today);：昨...
#counter([total|today|yesterday]);
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
