How to solve the problem when inserting Chinese data into mysql becomes a question mark

mysql inserts Chinese data into question marks

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

Chinese characters stored in mysql become question marks

Project scenario

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);

Problem description

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

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!