MySQL 查看编码排序规则

朴灿烈づ我的快乐病毒、 2024-03-27 09:39 96阅读 0赞

## MySQL 查看编码 排序规则 ##

![360 萬台以上 MySQL 伺服器，曝露於 Internet 上][360 _ MySQL _ Internet]

### 查看数据库的排序规则 ###

### 查看数据库的编码格式 ###

#### 查看字段的排序规则 ####

mysql> show create table tablename;

#### 查看表字段信息 ####

mysql> desc tablename;

#### 查看当前数据库编码 ####

mysql> use databasename;
    Database changed
    
    mysql> show variables like 'character_set_database'; 
    +------------------------+-------+
    | Variable_name          | Value |
    +------------------------+-------+
    | character_set_database | utf8  |
    +------------------------+-------+
    1 row in set (0.03 sec)

#### 修改当前数据库的编码 ####

mysql> use databasename;
    Database changed
    
    mysql> alter database databasename character set latin1;  #将之前的utf8编码修改为latin1编码
    Query OK, 1 row affected (0.00 sec)
    +------------------------+--------+
    | Variable_name          | Value  |
    +------------------------+--------+
    | character_set_database | latin1 |
    +------------------------+--------+
    1 row in set (0.00 sec)

#### 查看字段编码 ####

SHOW FULL COLUMNS FROM tablename;

#### 修改字段的字符集 ####

ALTER TABLE tablename CHANGE c_name c_name CHARACTER SET character_name [COLLATE ...];
    如：ALTER TABLE users CHANGE title title VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;

[360 _ MySQL _ Internet]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/27/9b8940260a3c46f0b3c513bc1e4bc94b.png