I have previously written an article about how to deal with mysql Chinese garbled characters. I found it is necessary to write this article again. The reason is that for security purposes, the official environment on the connection line of the mysql management tool is not allowed. In this case, the mysql management tool cannot be used to convert the encoding to solve Chinese garbled characters. In this case, only putty or
I have previously written an article about how to deal with mysql Chinese garbled characters. I found it is necessary to write this article again. The reason is that for security purposes, the official environment on the connection line of the mysql management tool is not allowed. In this case, the mysql management tool cannot be used to convert the encoding to solve Chinese garbled characters. In this case, only putty or
I have previously written an article about how to deal with mysql Chinese garbled characters. I found it is necessary to write this article again.
The reason is that for security purposes, the official environment on the connection line of the mysql management tool is not allowed. In this case, the mysql management tool cannot be used to convert the encoding to solve Chinese garbled characters.
In this case, you can remotely connect to the mysql server through putty or secureCRT, export the mysql database through the mysql command interface, and perform other encoding and conversion operations. The current environment is like this.
Now, to describe my data, I need to export a Chinese garbled data table account. user:
Mysql> show create database account;
+ ---- + -------------------------------- +
| Database | Create Database |
+ ---- + -------------------------------- +
| Account | create database 'account '/*! 40100 default character set utf8 COLLATE utf8_unicode_ci */|
+ ---- + -------------------------------- +
1 row in set (0.00 sec)
Mysql> show create table user;
+ ------- + Response-+
| Table | Create Table |
+ ------- + Response-+
| User_agreement_info | create table 'user '(
'Id' int (11) unsigned not null AUTO_INCREMENT,
'Uid' bigint (21) unsigned not null,
'Realname' char (32) not null,
'Id _ type' smallint (11) unsigned not null,
'Id _ num' char (32) default null,
'Create _ time' int (10) unsigned default null,
Primary key ('id '),
KEY 'uid' ('uid ')
) ENGINE = MyISAM AUTO_INCREMENT = 129287 default charset = utf8 |
+ ------- + Response-+
1 row in set (0.02 sec)
# Query data with garbled characters:
Mysql> select * from user limit 10;
+ -- + ---- + --------- + --- + ------- + ----- +
| Id | uid | realname | id_type | id_num | create_time |
+ -- + ---- + --------- + --- + ------- + ----- +
| 23 | 1000001229 | è