How to solve the problem of garbled codes in Korean in mysql

This article mainly explains "how to solve the problem of mysql Korean garbled code", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn how to solve the problem of mysql Korean garbled code.

The problem of garbled codes in mysql Korean

Because what I set up includes Korean, I would like to talk about the experience of solving the problem of garbled code in Korean here. Other Asian languages are pretty much the same.

To sum up, there are a few main steps (the red font is your own defined content, which can be replaced):

Www.2cto.com

1. When you set up the database, declare the default settings:

Create database database_name DEFAULT CHARSET=utf8

I use the utf8 format here, and I think you should try this format first. The first thing I tried was a special Korean setting, but it didn't solve the problem.

two。 After you have established the database, use the following command to view the status of the setting language:

SHOW VARIABLES LIKE 'character_set_%'

3. Set the value of other "variable_name" to also utf8:

Www.2cto.com

SET character_set_client = utf8

SET character_set_connection = utf8

SET character_set_results = utf8

SET character_set_database=utf8

SET character_set_server=utf8

Then you can start to set up a table under this database, insert values, and display Korean. I think it can also be displayed in Chinese.

At this point, I believe that everyone on the "mysql Korean garbled problem how to solve" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!