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

This article introduces the relevant knowledge of "how to solve the garbled problem encountered by MySql under Redhat5". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

I installed redhat and mysql on my, and accessed it locally through java, directly using jdbc.

Later, it was found that there was a garbled problem when the database stored Chinese characters, and then looked for information on the Internet to solve it. Now the problem has been solved, so let's summarize several problems of garbled code.

Change the database default character set encoding:

Change the configuration file, which is located in / etc/my.cnf. You may have this file after installing mysql. If not, go back to the root directory and query the cnf file:

Java code

Find /-iname'* .cnf'- print

Copy one of small.cnf, my-medium.cnf, my-huge.cnf, my-innodb-heavy-4G.cnf to / etc, and rename it to my.cnf:

Java code

Cp / usr/share/mysql/my-medium.cnf / etc/my.cnf

The copy path is modified according to the results of the query.

Modify my.cnf

Java code

Vi / etc/my.cnf

Add under [client]

Java code

Default-character-set=gbk

Add under [mysqld]

Java code

Default-character-set=gbk

Then restart mysql.

Log in to mysql to check whether the query is valid:

Java code

Mysql > show variables like 'collation_%'

Mysql > show variables like 'character_set_%'

Note that if you set UTF-8, please set utf8 instead of utf-8, otherwise your mysql will not start when it is restarted.

Modify the database character set after modifying the database character set:

Java code

Mysql > use mydb

Mysql > alter database mydb character set gbk

It is recommended that you specify the character set when you create the database

Java code

Mysql > create database mydb character set gbk

In addition to using the command to modify the character set of the data, you can also modify its configuration file

Modify / var/lib/mysql/mydb/db.opt

Java code

Default-character-set=latin1

Default-collation=latin1_swedish_ci

For

Java code

Default-character-set=gbk

Default-collation=gbk_general_ci

Restart MySQL

Note when building a table:

In addition to modifying the character set of mysql and its database, be aware that you may use exported SQL statements when building a table, which may contain the character set of the table. Be sure to modify or delete these statements:

Sql code

CREATE TABLE `NewTable` (

`id`int (11) NOT NULL

`name` varchar (50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL

`age` int (100) NULL DEFAULT NULL

PRIMARY KEY (`id`)

)

ENGINE=MyISAM

DEFAULT CHARACTER SET=gbk COLLATE=gbk_chinese_ci

CHECKSUM=0

ROW_FORMAT=DYNAMIC

DELAY_KEY_WRITE=0

In terms of connectivity:

If the database is configured correctly, there will be no problem using administrative tools such as Navicat for MySQL, but there will inevitably be problems in the program.

In addition to paying attention to the database, pay attention to specifying the character set of the connection when connecting to the database

Java code

Jdbc:mysql://192.168.154.128:3306/t2?useUnicode=true&characterEncoding=gbk

In terms of procedure:

But even here it may still be garbled, but it's not so serious, so you have to convert it in the code.

Java code

String newStr = new String (s.getBytes ("ISO-8859-1"), "GBK")

This is the end of the content of "how to solve the garbled problem encountered by MySql under Redhat5". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.