MySQL编码格式
时间:2021-07-01 10:21:17
帮助过:24人阅读
*/ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)
2) 查看表和字段的编码格式
mysql> show create table t_user;
+--------+----------------------------------------------------
--------------------------------------------------------------
-----------------------------------------------------------+
| Table | Create Table
|
+--------+----------------------------------------------------
--------------------------------------------------------------
-----------------------------------------------------------+
| t_user | CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(40)
CHARACTER SET utf8 DEFAULT NULL,
`birth` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=gbk |
+--------+----------------------------------------------------
--------------------------------------------------------------
-----------------------------------------------------------+
1 row in set (0.00 sec)
MySQL编码格式
标签:mysql 编码格式