Unknown character set index for field '255' received from server.

连接数据库时,出现Unknown character set index for field '255' received from server.

原因是MySQL版本高,mysql的jar版本低造成mysql与jar的编码错乱引起的,我的MYSQL是8.0版本

MYSQL 5.5 之前, UTF8 编码只支持1-3个字节;从MYSQL5.5开始,可支持4个字节UTF编码utf8mb4;

如emoji表情需要使用utf8mb4

更换前的jar

Unknown character set index for field '255' received from server.

 

错误信息

Unknown character set index for field '255' received from server.

 

------解----决---------

更换后的jar

Unknown character set index for field '255' received from server.

 

需升级jar包----->mysql-connector-java-5.1.46.jar或者更高,根据mysql版本决定

 

参考文档

https://blog.****.net/oldinaction/article/details/50489056