Sqlserver data transfer to MySQL

see mysql and sqlserver The default encoding method of the database
mysql：
show variables like 'character_set_%';
show variables like 'collation_%';
sqlserver：
SELECT COLLATIONPROPERTY('Chinese_PRC_Stroke_CI_AI_KS_WS', 'CodePage')
Here are the query results ：
936 Simplified Chinese GBK
950 Traditional Chinese BIG5
437 The United States / Canadian English
932 Japanese
949 Korean
866 ru
65001 unicode UFT-8

Chinese bytes
GBK The text encoding of is double byte ;
UTF－8 Coding rule , Use of Chinese 24 position （ Three bytes ） Encoding ;
sqlserver Single user and multi-user switching mode ：
perform SQL ALTER DATABASE db_database SET SINGLE_USER WITH ROLLBACK IMMEDIATE
Change to single user mode
perform SQL ALTER DATABASE db_database SET MULTI_USER
Then change to multi-user mode

 Create a character set of gbk Of mysql database ：MYSQL establish utf-8 Format database first mysql Get into ： Code GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;UTF8: CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;[root@linuxtest test]# mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 5Server 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) This test Library is utf-8 Format  

For the data transmission problem with inconsistent character coding format ：【sqlserver gbk code ,mysql utf8 code 】
Solutions ： Create a new one mysql database ,gbk code , Then through data transmission , Transfer data to utf8 Coded mysql In the database
Insert data from one table into another

insert into tb_grade (GradeName,NClassId)  SELECT g.`GradeName`, cg.`NClassID`FROM `grade` gINNER JOIN `classgrade` cg ON cg.`ClassGradeType`=g.`ClassGradeType`order by NClassId, GradeId asc 

author ： Winter moon

Game programming ️, A game development favorite ~

If the picture is not displayed for a long time , Please use Chrome Kernel browser .