mybatis --Unknown initial character set index ‘255‘ received from server. Initial client character

nknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.

从错误的提示信息中发现字符集设置出现问题

mysql连接数据库时报此错误：

//String url = "jdbc:mysql://localhost:3306/db_cjky" 如果使用这句就会报错。
//Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
String url = "jdbc:mysql://localhost:3306/db_cjky?useUnicode=true&characterEncoding=utf8";//改成这句，就可以了
————————————————

原文链接：https://blog.csdn.net/txwtech/article/details/80787886

原因：数据库字符集和mysql的驱动不搭配

解决：在数据库后面说明字符集

jdbc:mysql://localhost:3306/schedule（这里连接的是你的数据库名）?characterEncoding=utf-8

还要确定数据库是utf8的字符集

 

Unknown initial character set index '255' received from server. Initial client character错误 - 简书 

作者：SAYan_ffb9
链接：https://www.jianshu.com/p/5403b1ec2766
来源：简书
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。