spring数据jpa utf-8编码不起作用 [英] spring data jpa utf-8 encoding not working

问题描述

我使用spring-data-jpa和mysql数据库.我的表格字符集是utf-8.另外，我在application.properties文件中将?useUnicode=yes&characterEncoding=utf8添加到mysql url中.当我将±čęėį"之类的字符传递给控制器​​以将其保存在mysql中时出现问题.在MySQL中我得到了???分数.但是，当我使用mysql控制台示例update projects_data set data="ąęąčę" where id = 1;时，一切正常.

I use spring-data-jpa and mysql database. My tables character set is utf-8. Also I added ?useUnicode=yes&characterEncoding=utf8 to mysql url in application.properties file. Problem when I pass characters like "ąčęėį" to controller to save it in mysql. In mysql I got ??? marks. But when I use mysql console example update projects_data set data="ąęąčę" where id = 1; every works well.

application.properties:

application.properties:

# "root" as username and password.
spring.datasource.url = jdbc:mysql://localhost:3306/gehive?useUnicode=yes&characterEncoding=utf8
spring.datasource.username = gehive
spring.datasource.password = pass

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

# Show or not log for each sql query
spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update)
spring.jpa.hibernate.ddl-auto = update

# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy


# Use spring.jpa.properties.* for Hibernate native properties (the prefix is
# stripped before adding them to the entity manager)

# The SQL dialect makes Hibernate generate better SQL for the chosen database
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

表格:

+---------------+--------------------+
| TABLE_NAME    | character_set_name |
+---------------+--------------------+           
| customer      | utf8               |
| projects      | utf8               |
| projects_data | utf8               |
+---------------+--------------------+

推荐答案

尝试

spring.datasource.url = jdbc:mysql://localhost:3306/gehive?useUnicode=yes&characterEncoding=UTF-8

问题似乎是由于缺少-"引起的.

It seems issue is due to missing "-".

参考:- https://forum.hibernate.org/viewtopic.php ?f = 1& t = 1037497& view = next

这篇关于spring数据jpa utf-8编码不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！