When SecureCRT is connected to Linux, MySQL records Chinese garbled characters are displayed.

A view of the Linux host system Character Set echo $ LANGen_US.UTF-8 two ssh client characterencoding is set to default by default, as long as you change to the specified UTF-8

A View of Linux host system character Set echo $ LANG en_US.UTF-8 two ssh client character encoding default settings to default, as long as changed to the specified UTF-8

Homepage → Database Technology

Background:

Read News

When SecureCRT is connected to Linux, MySQL records Chinese garbled characters are displayed.

[Date:] Source: Linux community Author: Linux [Font:]

1. view the Linux host system Character Set echo $ LANG

En_US.UTF-8

Two ssh client character encoding default settings to default, as long as you change to the specified UTF-8 to display Chinese on the terminal.

SecureCRT settings: (After opening a Session, you can directly set the Session top selection option (Options)-> Session Options-> Appearance (Appearance)-> character (character encoding ), select UTF-8 default font Normal font select a Chinese font new 1010pt.

3. Note 1: View mysql Character Set settings

View the mysql server Character Set system variables:
Mysql> show variables like 'character _ % ';
Mysql> show variables like 'collation % ';
The character set of the final client connection is composed:

Note 2 character set can be specified during Client Connection

Mysql -- default-character-set = utf8

Note 3 the configuration file must be restarted after the character set is specified to change the configuration file.

[Client]

Set character_set_results = utf8

[Mysql]

Set character_set_results = utf8

0

Oracle OS Watcher installation and error handling

Backup script of the master database when MySQL4.0 is used as the master database

Related information: Chinese characters of SecureCRT garbled

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118