Now I want to send a number of reportedly mysql
I used to transfer data pipe to realize the following the source data is MSsqlserver, MYsql, target data is transmitted through a pipe, everything is successful, data are passed, but if the field, that is, if you have any Chinese in MYsql to turn into a chaos operator, other data no problem, I use the tool to open the MYsql manual writing Chinese no problem,
Master who met, please help under

CodePudding user response:

Use ODBC MYSQL straight

Configure ODBC

Under the connector options

Connect the options initial written statement: the set GBK names or UTF8

Because

Mysql is the default character_set_database itln1 what did European character set

Also can log in to Mysql

Then show the variables like "character_set_ %";

All the list all italiOOXX

The set character_set_OOXX="GBK"; Or "utf8"

CodePudding user response:

Top post, this problem is worth studying

CodePudding user response:

Mysql default character is Latin, character properties instead