spring mysql utf-8_mysql – spring data jpa utf-8编码不能正常工作

我使用spring-data-jpa和mysql数据库.我的表格字符集是utf-8.另外,我在application.properties文件中添加了?useUnicode = yes& amp; amp; featureEncoding = utf8到mysql url.当我将“ąčęėį”这样的字符传递给控制器​​以将其保存在mysql中时出现问题.在mysql我得到了???分数.但是当我使用mysql控制台示例更新projects_data set data =“ąęąčę”时,其中id = 1;一切顺利.

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 |

+---------------+--------------------+

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值