MySQL编码格式 - 数据库编程

意其中的数据库、表、列对应的编码格式没有包含关系。在建库、表、列时都可以设置编码格式。

mysql> alter database testjdbc character set gbk;

mysql> alter table t_user character set gbk;

mysql> alter table t_user modify name varchar(50) character set gbk;

(3) 查看数据库、表、字段的编码格式

1) 查看数据库编码格式

mysql> show create database testjdbc;
+----------+------------------------------------------------------------------+
| Database | Create Database |
+----------+------------------------------------------------------------------+
| testjdbc | CREATE DATABASE `testjdbc` /*!40100 DEFAULT CHARACTER SET gbk */ |
+----------+------------------------------------------------------------------+
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编码格式(二)