MYSQL中怎么設置字符集

今天就跟大家聊聊有關MYSQL中怎么設置字符集，可能很多人都不太了解，為了讓大家更加了解，小編給大家總結了以下內容，希望大家根據這篇文章可以有所收獲。

服務器級：

在my.cnf中設置，

mysql> show variables like 'character_set_server';
+--------------------------+--------------------------------------------------------------------------------------------------+
| Variable_name            | Value                                                                                            |
+--------------------------+--------------------------------------------------------------------------------------------------+
| character_set_server     | utf8                                                                                             |
+--------------------------+--------------------------------------------------------------------------------------------------+

數據庫級：
mysql> show variables like 'character_set_database';
+--------------------------+--------------------------------------------------------------------------------------------------+
| Variable_name            | Value                                                                                            |
+--------------------------+--------------------------------------------------------------------------------------------------+
| character_set_server     | utf8                                                                                             |
+--------------------------+--------------------------------------------------------------------------------------------------+

表級：
create table test (name varchar(100)) charset = utf8 collate=utf8_bin;

mysql> show create table test;
+-------+---------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                    |
+-------+---------------------------------------------------------------------------------------------------------------------------------+
| test  | CREATE TABLE `test` (
  `name` varchar(100) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
+-------+---------------------------------------------------------------------------------------------------------------------------------+

字段級：
create table test (name varchar(100) charset utf8 collate utf8_bin);

數據庫的字符集是utf8，如何在linux terminal上輸入中文字符。

1. 在linux terminal設置編碼格式為utf8

2. 設置環境變量為utf8
LANG="zh_CN.utf8"
LC_ALL="zh_CN.utf8"
LANG="en_US.utf8"
LC_ALL="en_US.utf8"
export LANG
export LC_ALL

3. 設置mysql connection屬性為utf8
set names utf8

下面是測試結果：
1. 建立測試表。
create table test ( name varchar(30));

2. 編輯sql語句腳本
more test.sql
set names utf8;
insert into test values ('中文');
insert into test values ('中文二');
insert into test values ('字符集');

3. 執行sql
mysql -uroot -p --database=mydb < test.sql
Enter password:

mysql -uroot --database=mydb -e 'select * from test';
+-----------+
| name      |
+-----------+
| 中文      |
| 中文二    |
| 字符集    |
+-----------+

看完上述內容，你們對MYSQL中怎么設置字符集有進一步的了解嗎？如果還想了解更多知識或者相關內容，請關注億速云行業資訊頻道，感謝大家的支持。