1.使用create database语句创建数据库 mysql> create database if not exists test03default character set= 'utf8'; Query OK, 1 row affected (0.00 sec) 备注:通过default character set = 语句来指定DB的字符集. 2.查看创建的DB的字符集 mysql>selectschema_name,default_character_set_namefrominformation_...
查看数据库字符集
create database db1 DEFAULT CHARACTER SET utf8 COLLATE utf8_chinese_ci;
1.使用create database语句创建数据库 mysql> create database if not exists test03 default character set = 'utf8'; Query OK, 1 row affected (0.00 sec) 备注:通过default character set = 语句来指定DB的字符集. 2.查看创建的DB的字符集 mysql> select schema_name,default_character_set_name from in...