Home >Database >Mysql Tutorial >How to solve the problem when inserting Chinese data into mysql becomes a question mark
Step one: First check the basic configuration of your own code
1. Behind the Jdbc.properties database configuration file Have you added characterEncoding=utf-8, as shown in the picture below:
If you find it’s not there, don’t just look at it, add it up quickly
2.web Is the .xml configured with an encoding filter, like this
# If not, you can figure it out yourself. Hehe, for your convenience, copy and write it below (right? Very considerate)
<!-- 配置编码过滤器 --> <filter> <filter-name>characterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter>
Step 2: When you find that there is no problem with the above two files, let’s take a look at this configuration file.
1. Look at the database encoding format
First log in to the server, enter your database, and log in to the database command (the database name below refers to the name of the database you created, such as test):
mysql - u root -p database name
Then execute the following command to check the encoding format of your database
show variables like ‘char%’;
It is this latin1 that is causing trouble, so how to solve this problem? Don’t be impatient and read on.
2. Modify the mysql internal configuration file
Let me first state that the latest downloaded official mysql installation package does not seem to have a my.ini file, but it must have my.ini file. cnf file, at this time you should go to your server to see where it is. Of course, it is usually under etc/ in the root directory.
Command line: vim my.cnf
[Core] Execute the i command to enter the editing mode, and add the following sentence under [mysqlid], also That is, the Chinese character encoding format is compatible
character-set-server=utf8
: The wq command saves and exits.
3. Restart mysql and you're done
I executed these two implementations under the bin in the root directory to stop and start
systemctl stop mysqld.service systemctl start mysqld.service
Then You can proudly log in to mysql and execute the above command to check the encoding format of your database
show variables like ‘char%';
Isn’t it surprising and unexpected, hahahaha.
In the end, after unremitting efforts, I finally entered the Chinese data. Hahahaha, I really convinced myself that I wanted to transfer money to myself. I can just leave the question marks.
Problem Solving
mySql 5.7
java
Configuration file: spring.datasource.url=jdbc:p6spy:mysql://localhost:3306/XXX?useSSL=false
Insert operation :
@Insert("INSERT INTO foods(food_name,food_taste,food_price,food_description) VALUES (#{foodName},#{foodTaste},#{foodPrice},#{foodDescription})") int insert(Food food);
What will the Chinese characters become after being stored in the database? ? ? ?
Cause analysis:
The settings for connecting to the database require a character set
Solution: data Add useUnicode=true&characterEncoding=UTF-8
spring.datasource.url=jdbc:p6spy:mysql://localhost:3306/XXX?useUnicode=true&characterEncoding=UTF-8&useSSL=false
wenti
in the source.The above is the detailed content of How to solve the problem when inserting Chinese data into mysql becomes a question mark. For more information, please follow other related articles on the PHP Chinese website!