mysql乱码

最新推荐文章于 2024-09-17 12:26:00 发布

jackyMing明

最新推荐文章于 2024-09-17 12:26:00 发布

阅读量78

点赞数

分类专栏： mysql 文章标签： mysql utf8

本文链接：https://blog.csdn.net/b151555/article/details/84607510

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.解决方案1
jdbc_url 后面添加编码
jdbc:mysql://[host:port],[host:port].../[database][?参数名1][=参数值1]
characterEncoding=utf8
2.解决方案2
数据库编码设置为utf8
[img]http://dl2.iteye.com/upload/attachment/0098/1893/13e985f9-683d-3ead-b1d4-dc1b52e3dd5a.jpg[/img]
3.解决方案3
表字段设置为utf8
[img]http://dl2.iteye.com/upload/attachment/0098/1895/31feb99b-fbfd-3666-bbfd-dcd58d8dce08.jpg[/img]
4.解决方案4
jsp页面设置utf8或者程序拦截转码utf8
[img]http://dl2.iteye.com/upload/attachment/0098/1897/4a68cbb4-f27e-3d0f-986a-24308194a2b7.jpg[/img]
5.解决方案5
查看数据库配置,sql进行更改
show variables like 'character%';
SET character_set_client = utf8;
SET character_set_connection = utf8;
SET character_set_database = utf8;
SET character_set_results = utf8;
SET character_set_server = utf8;
[img]http://dl2.iteye.com/upload/attachment/0098/1899/b900d639-fe33-36ab-b6c6-2a70a8b9dfa5.jpg[/img]
6.解决方案6
更改mysql 安装目录 my.ini文件中的character-set-server=utf8