gbk编码的数据导入到utf8编码的数据库_MySQL
Jun 01, 2016 pm 01:26 PMbitsCN.com
编码是utf8的数据库，如果要导入gbk或其他编码的数据，可以在navicat数据库右键，选择运行sql文件，在这里选择编码格式，导入即可。
如果没有装navicat，其他方式：
1.用文本工具打开sql文件，找到创建表的sql语句，手动把gbk编码替换成utf8
2.使用sql语法，如果比较少字段, 可用函数CONVERT( XXX USING GBK)
3.或者把gbk数据库导出的时候设置utf8编码，再导入到utf8的数据库
原文链接：http://www.tantengvip.com/2013/12/gbk-utf8-import/
bitsCN.com
Hot Article
Hot tools Tags
Hot Article
Hot Article Tags
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to use sql statement to query the storage structure of mysql database
Apr 14, 2024 pm 07:45 PM
How to use sql statement to query the storage structure of mysql database
How to export the queried data in navicat
Apr 24, 2024 am 04:15 AM
How to export the queried data in navicat
How to solve mysql database initialization failure
Apr 14, 2024 pm 07:12 PM
How to solve mysql database initialization failure
How to execute sql statement in mysql database
Apr 14, 2024 pm 07:48 PM
How to execute sql statement in mysql database
Detailed tutorial on establishing a database connection using MySQLi in PHP
Jun 04, 2024 pm 01:42 PM
Detailed tutorial on establishing a database connection using MySQLi in PHP
How does Hibernate implement polymorphic mapping?
Apr 17, 2024 pm 12:09 PM
How does Hibernate implement polymorphic mapping?
iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos
Jul 18, 2024 am 05:48 AM
iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos
