表现
mysql存入汉字为问号.png
参数
{
"name": "测试3",
"image": "https://www.baidu.com/img/PCtm_d9c8750bed0b3c7d089fa7d55720d6cf.png",
"letter": "C",
"seq": null
}
接口sql打印
==> Preparing: INSERT INTO tb_brand ( id,name,image,letter,seq ) VALUES( ?,?,?,?,? )
==> Parameters: null, 测试3(String), https://www.baidu.com/img/PCtm_d9c8750bed0b3c7d089fa7d55720d6cf.png(String), C(String), null
application.yml配置文件
url: jdbc:mysql://127.0.0.1:3306/changgou_goods?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
结论
配置文件数据库连接编码错误,配置文件应修改为
url: jdbc:mysql://127.0.0.1:3306/changgou_goods?characterEncoding=utf-8&useSSL=false