Unknown initial character set index '255' received from server. Initial client character set can be

在连接mysql数据库是经常会出现一些莫名其妙的错误,截图如下:

Unknown initial character set index '255' received from server. Initial client character set can be

如果是这样的错误那么你不用慌这是SQL转码出现了错误,在数据库的URL这块加上“?characterEncoding=utf8&useSSL=false&useUnicode=true”这句问题就解决了。完整的句式如下:(J2EE处写你的数据库名称)

String url="jdbc:mysql://localhost:3306/J2EE?characterEncoding=utf8&useSSL=false&useUnicode=true";