Shulou(Shulou.com)05/31 Report--

MSSQL to MYSQL and gb2312 to utf-8 no garbled solutions, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Use software: MySQLMigrationTool prompt data is too large to import. Modify the max_allowed_packet of the my.cnf file above 100m. In the windows operating system, my.cnf may not be displayed, so you need to enter the address directly with the editor: drive letter:\ directory mysql tutorial binmy.cnf to open. "there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause", MSSQL there are more than two date-time fields in a table that use getdate () to take the default value, which can be removed. "BLOB/TEXT column 'table name' can't have a default value". The default value is not allowed in this field. Just remove it. "The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs", the fields in this table take up too much space, so reduce the number or length of fields appropriately.

After running the software, click NEXT to enter the following interface:

Select MS SQL SERVER and enter as prompted. The Connection String is:

Jdbc:jtds:sqlserver://IP address: Port (default 1433) / database tutorial name; user= user name; password= password; charset=gb2312;domain=

The next step is the information of MySQL. The Connection String is:

Jdbc:mysql://IP address: Port (default 3306) /? user= username & password= password & useServerPrepStmts=false&characterEncoding=UTF-8

Then follow the instructions all the way. Go to this interface and select the table you want to ignore.

Continue NEXT and enter this interface as shown in the figure, where it is critical to set character encoding.

Mssql import mysql non-garbled MySQLMigrationTool MySQL GUI Tools 5.0 includes MySQLMigrationTool this tool can complete our task this tool needs the support of JRE update 8 or above, can be downloaded from sun.com, very fast. Some students in http://www.java.com/zh_CN/download/manual.jsp run the mysql and the result is garbled in Chinese. That is because there is a step of choosing a code in the middle of a next. Here, be sure to select user defined, and fill in charset=gbk,coll...tion equals gbk_chinese_ci, that is, change latin and swidish to Chinese corresponding. Anyway, keep an eye on it here, or there's no one else to blame for the garbled code. And then next all the way.

After reading the above, have you mastered the solution of MSSQL to MYSQL and gb2312 to utf-8 without garbled code? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.