[size=large]
使用的mysql5.7.10
[color=orange]1首先检查spring配置[/color]
<property name="jdbcUrl" value="${jdbcUrl}"></property>
jdbcUrl是否为:
jdbc:mysql://localhost:3306/wind?true&characterEncoding=utf8
[color=red] 最主要是否有true&characterEncoding=utf8[/color]
[color=orange] 2查看mysql数据库编码[/color]
@1查看最底层的
show variables like '%char%'
show variables like 'collation_%'
修改:
set character_set_client=utf8;
set character_set_database=utf8;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
set collation_connection=utf8_general_ci;
set collation_database=utf8_general_ci;
set collation_server=utf8_general_ci;
@2 查看你的database的,表的,字段的数据编码
@3 搞不定,请另行思考
[/size]
使用的mysql5.7.10
[color=orange]1首先检查spring配置[/color]
<property name="jdbcUrl" value="${jdbcUrl}"></property>
jdbcUrl是否为:
jdbc:mysql://localhost:3306/wind?true&characterEncoding=utf8
[color=red] 最主要是否有true&characterEncoding=utf8[/color]
[color=orange] 2查看mysql数据库编码[/color]
@1查看最底层的
show variables like '%char%'
show variables like 'collation_%'
修改:
set character_set_client=utf8;
set character_set_database=utf8;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
set collation_connection=utf8_general_ci;
set collation_database=utf8_general_ci;
set collation_server=utf8_general_ci;
@2 查看你的database的,表的,字段的数据编码
@3 搞不定,请另行思考
[/size]