mysqlcreatedatabase指定utf-8編碼

mysqlcreatedatabase指定utf-8編碼

如下腳本創建數據庫yourdbname，並制定默認的字符集是utf8CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;如果要創建默認gbk字符集的數據庫可以用下面的sql:create database yourdb DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;