The solution of MySQL inserting Chinese errors

@ Catalog

Problem introduction

Get to know the database , When trying to insert Chinese data , You may encounter some error messages ;

On the premise that the database and table are created correctly , We try to insert Chinese “ Zhang San ”, Errors found ;
What's the reason ？

Background introduction

In the database , Expressing Chinese , Clear character encoding is required （ Character set ）;
MYSQL The default character set is “ Latin ”, This character set does not support Chinese ;

terms of settlement

Here is a way to do it once and for all ： modify mysql Configuration file for

• Determine the character set of the current database

This operation is to prevent the secondary modification of the database that has undergone configuration modification
Use command show variables like ‘character%’;

The above picture shows , That is, you need to modify its configuration file

• Find the configuration file （my.ini）

The specific search steps are as follows :

1. Start menu bar find MYSQL Shortcut to — Right click — more — Open file location
   
   
2. In the location of the file — Right click — attribute — The goal is

3. Copy the contents of the target completely to Notepad , You can see that my.ini Path to file

4. Copy the path to the file, and the file manager will find my.ini file

5. Modify the configuration file

Before modifying the configuration file , To back it up （ Copy — Paste ）;

Edit profile — Notepad open — Find the following 2 The plate part of the picture — Modify as shown in the figure

5. restart MYSQL The server （ Must be carried out , Otherwise, it will not take effect ）

Found in service MYSQL— Right click — Restart , that will do

in addition , Modify the configuration file , It will not affect the database created before modification , So you want to use a new configuration file for the database , The database and table must be rebuilt ;

Problem verification

After modifying the configuration file , Restart the server , Then build the database and table again ;

Try inserting Chinese

You can see , Chinese inserted successfully .

over！