Detailed explanation of the Chinese garbled problem in mysql database-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Detailed explanation of the Chinese garbled problem in mysql database

小云云

Dec 08, 2017 pm 01:05 PM

mysql Garbled characters database

This article mainly introduces relevant information on the detailed explanation of the Chinese garbled problem in mysql database. Friends in need can refer to it.

When inserting a piece of data with Chinese characters into the MySQL database, the shape is insert into employee values(null,'Zhang San','female','1995-10-08','2015-11 -12','Sales',2000,'What a good employee! '); When garbled characters appear, you can use the statement show variables like 'character%'; to view the relevant encoding set of the current database. .

As you can see from the above figure, MySQL uses character sets in six places, namely: client, connection, database, results, server, and system. Among them, related to the server: database, server, system (can never be modified, it is utf-8); related to the client: connection, client, results.

##resultsWhen the database returns to the client The character set to use. If not specified, the server's default character set will be used.

client	is The character set used by the client.
connection	## is the character set setting for connecting to the database Type, if the program does not specify the character set type used to connect to the database, the server-side default character set setting will be used.
##database	is a library in the database server The character set setting used, if not specified when building the database, will use the character set setting specified when the server is installed.

server	is the default character set setting specified during server installation.
system	## is the character set used by the database system set up.

After understanding the above information, let’s analyze the cause of the garbled characters. The problem lies in the current CMD. In the client window, because the current CMD client input uses GBK encoding, and the encoding format of the database is UTF-8, inconsistent encoding results in garbled characters. The encoding format of the current CMD client cannot be modified, so the encoding set of connection, client, and results can only be modified to inform the server that the currently inserted data uses GBK encoding. Although the server's database uses UTF-8 encoding, it can be recognized Notify the server side of GBK encoded data and automatically convert it to UTF-8 for storage. You can use the following statement to quickly set the encoding set related to the client:

set names gbk;

It can be solved after the setting is completed There is a garbled problem when inserting data or displaying data on the client, but we will soon find that this form of setting will only be effective in the current window. When the window is closed and the CMD client is reopened, the garbled problem will appear again; then, how to make a What about a set-and-forget setup? There is a my.ini configuration file in the MySQL installation directory. By modifying this configuration file, you can solve the garbled problem once and for all. In this configuration file [mysql] is related to the client configuration, and [mysqld] is related to the server configuration. The default configuration is as follows:

[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8

At this time, you only need to change the default encoding default-character Change -set=utf8 to default-character-set=gbk and restart the MySQL service.

Have you learned it? Hope it can solve the urgent need.

Related recommendations:

Summary of solutions to Chinese garbled characters in mysql database

##Solutions to Chinese garbled characters in PHP connection to MySQL database_ PHP tutorial

How to solve Chinese garbled characters in mysql database. Modifying the character encoding in the configuration file has no effect

The above is the detailed content of Detailed explanation of the Chinese garbled problem in mysql database. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks ago By DDD

Nordhold: Fusion System, Explained

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1664

CakePHP Tutorial

1423

Laravel Tutorial

1321

PHP Tutorial

1269

C# Tutorial

1249

Related knowledge

MySQL and phpMyAdmin: Core Features and Functions Apr 22, 2025 am 12:12 AM

MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.

Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

Explain the purpose of foreign keys in MySQL. Apr 25, 2025 am 12:17 AM

In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.

Compare and contrast MySQL and MariaDB. Apr 26, 2025 am 12:08 AM

The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.

SQL vs. MySQL: Clarifying the Relationship Between the Two Apr 24, 2025 am 12:02 AM

SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.

Redis: Understanding Its Architecture and Purpose Apr 26, 2025 am 12:11 AM

Redis is a memory data structure storage system, mainly used as a database, cache and message broker. Its core features include single-threaded model, I/O multiplexing, persistence mechanism, replication and clustering functions. Redis is commonly used in practical applications for caching, session storage, and message queues. It can significantly improve its performance by selecting the right data structure, using pipelines and transactions, and monitoring and tuning.

How to safely store JavaScript objects containing functions and regular expressions to a database and restore? Apr 19, 2025 pm 11:09 PM

Safely handle functions and regular expressions in JSON In front-end development, JavaScript is often required...

MySQL: The Database, phpMyAdmin: The Management Interface Apr 29, 2025 am 12:44 AM

MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.

See all articles