在MySQL中设置列字符集？

使用字符SET命令设置列字符集。语法如下-

ALTER TABLE yourTableName MODIFY youColumName type CHARACTER SET anyCharcaterSetName;

您可以使用字符集名称utf8或其他elsE。要设置列字符集，让我们首先创建一个表。创建表的查询如下-

mysql> create table setCharsetDemo
   −> (
   −> FirstName varchar(60)
   −> );

现在，您可以在show命令的帮助下检查当前列字符集。查询如下-

mysql> show create table setCharsetDemo;

以下是输出-

+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table          | Create Table                                                                                                                                                           |
+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| setCharsetDemo | CREATE TABLE `setcharsetdemo` (`FirstName` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci |
+----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

现在您可以看一下上面的示例输出。默认字符集为utf8mb4。让我们将字符集设置为utf8mb4以外的其他字符集。

我们将字符集设置为utf8。查询如下-

mysql> alter table setCharsetDemo modify FirstName varchar(60) CHARACTER SET utf8;
Records: 0 Duplicates: 0 Warnings: 1

让我们检查字符集是否已更改。查询如下-

mysql> show create table setCharsetDemo;

以下输出显示我们已经成功更新了字符集-

+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table          | Create Table                                                                                                                                                                          |
+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| setCharsetDemo | CREATE TABLE `setcharsetdemo` (`FirstName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci |
+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)