About Chinese encoding in the database

codename19

There is a problem that I have not understood. I use JDBC to write a record to mysql. I write Chinese directly in Java programs. But what I see in mysql is garbled.

What's going on with this question?

Thank you all!

noendenergy

Modifying mysql's default character set is achieved by modifying its configuration file. There are two general situations:
[edit]
Windows platform

The mysql configuration file under windows is my.ini, generally in c:\windows\my.ini or c:\winnt\my.ini can be directly added in this file

default-character-set = gbk #or gb2312, big5, utf8

Then restart mysql

service mysql restart

or

/etc/init.d/mysql restart

Or restart by other methods, it will take effect.
[edit]
Unix platform

The mysql configuration file under Linux is my.cnf, usually /etc/my.cnf. If you can't find it, you can find it with the find command:

find / -iname my.cnf

Add in this file

default-character-set = gbk #or gb2312, big5, utf8

Then restart mysql

net stop mysql
net start mysql

It took effect.

codename19

Thank you. I try first.

期待爱情

Create the table as shown CREATE DATABASE `test` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

codename19

Tonoendenergy:
It doesn't seem to work. I use linux, mycnf is like this:
[mysqld]
#This option makes InnoDB to store each created table into its own .ibd file.
innodb_file_per_table
default-character-set=utf8

But when I use the database management tool to see it is still garbled, when I use the mysql command on the command line, it is still garbled (my console is also UTF8). But it is right to read from the database to the Java String. So my program runs without any coding inconsistencies, but when I enter the database, it is garbled. why?

To期待爱情:

I use a database management tool to see that the Charset of each field in the table is UTF8 encoded. The locale of my operating system is UTF8. Why are there still inconsistencies?

Thank you!

dylnnet

Probably UTF-8 cannot be viewed directly.

rechall

1. The url parameter in the Connection of jdbc: jdbc:mysql://localhost/DATABASE_NAME?useUnicode=true&characterEncoding=UTF-8,
Among them, "useUnicode=true&characterEncoding=UTF-8" is there, if not, add it.

2. When creating a database:
create database DATABASE_NAME DEFAULT CHARACTER SET utf8;
Among them: "DEFAULT CHARACTER SET utf8" should be added, which means that all tables and fields (char, varchar) under the database DATABASE_NAME default to utf8.


In addition, if you look at mysql, is it in the command line state under linux or under MySQL Query Brower?
If you look at the Linux command line, most of them will be garbled. If the MySQL Query Brower is garbled, just change it according to the above 2 points.

codename19

Yep. Indeed, it is no problem with Query Browser, but not under the command line (my locale is already utf8.) Who has the solution?

codename19

Thank you. Under your prompt, I thought of looking up mysql parameters and found --default-character-set=utf8. Okay.
Thank you!