展开全部
MYSQL创建utf-8格式的数据库方法:
先mysql进入;e5a48de588b63231313335323631343130323136353331333365646262
Linux代码 ;
GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
UTF8: CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE ;utf8_general_ci;
eg;
[root@linuxtest test]# mysql -u root -p ;
Enter password;
Welcome to the MySQL monitor. Commands end with ; or \g;
Your MySQL connection id is 5;
Server version: 5.1.30-community MySQL Community Server (GPL) ;
Type 'help;' or '\h' for help. Type '\c' to clear the buffer;
mysql> CREATE DATABASE `test` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.06 sec) ;
mysql> show databases;
+--------------------+ ;
| Database | ;
+--------------------+ ;
| information_schema | ;
| cacti | ;
| mysql | ;
| test | | ;
+--------------------+ ;
5 rows in set (0.07 sec) ;
这个test库就是utf-8格式的 。