How to use the character set character in MySQL database-Mysql Tutorial-php.cn

1. Character set character

Charactercharacteris the general name for various characters and symbols
Character encodingcharacter codeis a binary storage code in the computer for various symbols
Character setcharacter setis a number of characters Collection of

Common character sets:

ASCII character set
GB2312 Character set
Unicode character set

2. Set the client character set

-- 设置客户端字符集编码 set names gbk; -- 查看字符集编码设置 show variables like 'character_set_%'; +--------------------------+------------+ | Variable_name | Value | +---------+-----------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | utf8mb4 | | character_set_system | utf8 | | character_sets_dir | /usr/local/Cellar/mysql/8.0.16/share/mysql/charsets/ | +--------------------------+------------+ -- 插入中文字符 insert into tb_teacher (name, age) values ('张三', 23);

Copy after login

MySQL There are three layers between MySQLd:

The client passes in data to the serverclient
service The end returns data to the clientserver
Connection between client and servercollection

##Variables:

character_set_clientClient
character_set_connectionConnection layer
character_set_databaseDatabase
character_set_resultsResult set

Modify variables:

set 变量名 = 值; -- 修改单个变量 set character_set_client = gbk; -- 设置字符集 set names gbk; -- 等价于 set character_set_client = gbk; // 让服务器识别客户端传过去的数据 set character_set_connection = gbk; // 更好的帮助客户端与服务器端之间惊醒字符集转换 set character_set_results = gbk; // 告诉客户端服务器返回的数据

Copy after login

The above is the detailed content of How to use the character set character in MySQL database. For more information, please follow other related articles on the PHP Chinese website!