在建立数据表的时候,我们可能会忘记选择数据库字符编码方式,而默认一般是latin。
首先先登录数据库,然后选择你需要操作的数据库(不同数据库之间的编码方式是独立的).
紧接着,你需要输入“ \s ”,然后你就能看见一些消息。
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.5.28, for Win32 (x86)
Connection id: 143
Current database: banksystem
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.5.28 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 1 day 10 hours 14 min 15 sec
然后可以开始行动了在mysql选定数据库后输入:
mysql> set character_set_client=utf8;
mysql> set character_set_connection=utf8;
mysql> set character_set_database=utf8;
mysql> set character_set_results=utf8;
mysql> set character_set_server=utf8;
mysql> set character_set_system=utf8;
mysql> set collation_connection=utf8;
mysql> set collation_database=utf8;
mysql> set collation_server=utf8;
即可设置为utf-8,也可以选定其他类型。
修改数据库的字符集
mysql>use mydbmysql>alter database mydb character set utf8;
创建数据库指定数据库的字符集
mysql>create database character set utf-8(待验证语法是否正确)
mydb character set utf8;