4、MySQL-修改数据库编码方式

来源：互联网发布：linux p2p服务器编辑：程序博客网时间：2024/06/04 00:58

ALTER {DATABASE|SCHEMA} db_name [[DEFAULT] CHARACTER SET [=] 字符集] ;

mysql> SHOW CREATE DATABASE learndb2;
+----------+------------------------------------------------------------------+
| Database | Create Database |
+----------+------------------------------------------------------------------+
| learndb2 | CREATE DATABASE `learndb2` /*!40100 DEFAULT CHARACTER SET gbk */ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> ALTER DATABASE learndb2 DEFAULT CHARACTER SET = 'UTF8';
Query OK, 1 row affected (0.00 sec)

mysql> SHOW CREATE DATABASE learndb2;
+----------+-------------------------------------------------------------------+
| Database | Create Database |
+----------+-------------------------------------------------------------------+
| learndb2 | CREATE DATABASE `learndb2` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------------+

0 0