GBK資料庫轉換UTF8

-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)---- Host: localhost    Database: chardb-- -------------------------------------------------------- Server version5.5.16-log/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `student`----將GBK資料庫轉成UTF8資料庫mysqldump -hlocalhost -uroot -proot world --character-set=utf8>world.sql-- 　先將資料匯出成UTF8的SQL資料，script.sql,然後將匯入的SQL檔案中將表中的 character set 改成 utf8,然後將 default character set 也改成utf8--   在匯入的SQL中加入以下語句:  drop database XXX(刪除原來的資料庫); create database XXX default character set utf8(建立一個新的資料庫，character set 為utf8);use XXX(進入建立的資料庫)-- 在後執行下面命令 : mysql -hlocalhost -uroot -proot<script.sqldrop database if exists chardb;create database chardb default character set utf8;use chardb;DROP TABLE IF EXISTS `student`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `student` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(20) NOT NULL DEFAULT '',  `class` varchar(20) NOT NULL DEFAULT '',  PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `student`--LOCK TABLES `student` WRITE;/*!40000 ALTER TABLE `student` DISABLE KEYS */;INSERT INTO `student` VALUES (1,'張三','一班'),(2,'李四','二班');/*!40000 ALTER TABLE `student` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `teacher`--DROP TABLE IF EXISTS `teacher`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `teacher` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(30) NOT NULL DEFAULT '',  PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `teacher`--LOCK TABLES `teacher` WRITE;/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;INSERT INTO `teacher` VALUES (1,'趙東江'),(2,'劉紅旗');/*!40000 ALTER TABLE `teacher` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2012-04-10  8:31:45