mysql> show character set like '%utf%';
+---------+---------------+--------------------+--------+
| Charset | Description | Default collation | Maxlen |
+---------+---------------+--------------------+--------+
| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |
| utf8mb4 | UTF-8 Unicode | utf8mb4_general_ci | 4 |
+---------+---------------+--------------------+--------+
2 rows in set (0.00 sec)
mysql> show character set like '%utf%';
+---------+---------------+--------------------+--------+
| Charset | Description | Default collation | Maxlen |
+---------+---------------+--------------------+--------+
| utf8 | UTF-8
mysql 查看排序集
最新推荐文章于 2023-05-06 08:30:00 发布
该博客介绍了如何在 MySQL 中使用 `show character set` 和 `show collation` 命令来查看与 UTF-8 相关的字符集和排序规则。内容包括了 `utf8` 和 `utf8mb4` 两种字符集及其默认的排序集。
摘要由CSDN通过智能技术生成