--查看数据库的字符集
show variables like 'character\_set\_%';
show variables like 'collation_%';
--设置数据库字符编码
set names “uft8”
alter database payment character set uft8;
create database mydb character set uft8;
set character_set_client=uft8;
set character_set_connection=uft8;
set character_set_database=uft8;
set character_set_results=uft8;
set character_set_server=utf8;
set character_set_system=uft8;
set collation_connection=uft8;
set collation_database=utf8;
set collation_server=uft8;
show variables like 'character\_set\_%';
show variables like 'collation_%';
--设置数据库字符编码
set names “uft8”
alter database payment character set uft8;
create database mydb character set uft8;
set character_set_client=uft8;
set character_set_connection=uft8;
set character_set_database=uft8;
set character_set_results=uft8;
set character_set_server=utf8;
set character_set_system=uft8;
set collation_connection=uft8;
set collation_database=utf8;
set collation_server=uft8;
本文介绍如何使用MySQL命令来查看和设置数据库的字符集。通过一系列的SQL指令展示如何为整个数据库环境设定统一的UTF-8编码标准。

1577

被折叠的 条评论
为什么被折叠?



