java.sql.SQLException: Unknown initial character set index ‘255‘ received from server.

最新推荐文章于 2023-07-11 10:27:32 发布
最新推荐文章于 2023-07-11 10:27:32 发布
阅读量733 收藏 1
点赞数
文章标签： java sql jar
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yi234567bo/article/details/121895691
版权
本文讲述了在将jar包从mysql-connector-java-5.1.7-bin.jar更新到mysql-connector-java-8.0.11.jar后，数据库连接遇到字符集问题的解决过程，重点在于初始字符集设置的调整。
摘要由CSDN通过智能技术生成

控制台报错：

com.alibaba.druid.support.logging.JakartaCommonsLoggingImpl error
严重: create connection SQLException, url: jdbc:mysql://localhost:3306/userDb, errorCode 0, state S1000
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.

把jar包从mysql-connector-java-5.1.7-bin.jar
换成mysql-connector-java-8.0.11.jar，问题解决

一234567博
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
java.sql.SQLException: Unknown initial character set index '255' received from server. .....
热门推荐
flashtown的博客
08-18 1万+
开始出现错误（1） java.sql.SQLException:Unknowninitialcharactersetindex'255'receivedfromserver.Initialclientcharactersetcanbeforcedviathe'characterEncoding'property.错误提示 根据提示在连接数据库时增加编码 ...
java.sql.SQLException: Unknown initial character set index ‘255‘ received from server. Initial clien
qq_41530024的博客
01-15 226
java.sql.SQLException: Unknown initial character set index ‘255’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property 原因：未知字符 默认字符集已从latin1变成utf8mb4 解决： 前： 后： ...
mysql java.sql.SQLException: Unknown initial character set index ‘255‘ received from server
qq 117791303
01-11 802
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property. Class.forName("com.mysql.jdbc.Driver"); private static String url = "jdbc:mysq...
java.sql.SQLException: Unknown initial character set index '255' received from server.
weixin_43256484的博客
04-22 1574
这是由于mysql-connector-java 的版本问题造成的 问题发生在mysql 8.0的更改中:默认字符集已从latin 1更改为utf8mb4 这些系统变量受到影响： character_set_server and character_set_database系统变量的默认值从latin1 to utf8mb4. the collation_server and collation_...
连接Mysql数据库的报错: java.sql.SQLException: Unknown initial character set index ‘255’ received from server
weixin_61635597的博客
10-19 3207
连接Mysql数据库的报错: java.sql.SQLException: Unknown initial character set index ‘255’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.原因及其解决方案
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
java.sql.SQLException: 结果集已耗尽
08-02
在Java编程中，`java.sql.SQLException: 结果集已耗尽` 是一个常见的错误提示，通常出现在处理数据库查询结果集时。这个异常表明程序试图访问已经没有数据的结果集中下一行，即所有行已经被遍历完，尝试访问超出范围...
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
09-29
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
报错：java.sql.SQLException: Unknown initial character set index ‘255‘。。。‘characterEncoding‘ property.
qq_56415090的博客
08-03 343
当你使用框架，用main方式执行sql语句，结果报错： java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property. 那可能原因是数据库编码的问题， 可以在eeys（数据库名）后边加入： ?useUnicode=true&
java.sql.SQLException: Unknown initial character set index ‘255‘ received from server. Initial...
m0_46202433的博客
08-10 476
java.sql.SQLException: Unknown initial character set index ‘255’ received from server. Initial client character set 在编写Jdbc的时候遇到这样的问题。往往的问题就是sql的jar版本过低，更新一个更高的版本就号啦。然后把原本的jar包给删除掉。...
java.sql.SQLException: Unknown initial character set index ‘255‘ received from server.（获取连接对象时）
weixin_49675807的博客
08-06 497
原因： 1.MySQL v.8.0默认字符集已从 latin1 更改为 utf8mb4导致一些系统变量改变 2.mysql-connector-java 新版本也会将mysql默认字符集已从 latin1 更改为 utf8mb4导致一些系统变量改变. 解决方法：url=jdbc:mysql://localhost:3306/数据库名?characterEncoding=latin1&useConfigs=maxPerformance 有误请指正，谢谢。 ...
解决问题：Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ received from server.
最新发布
qq_41626421的博客
07-11 509
/改成这句，就可以了。解决：//jdbc.url = "jdbc:mysql://localhost:3306/spring_db" 如果使用这句就会报错。
Unknown initial character set index ‘255‘ received from server.
weixin_44311548的博客
06-05 185
Unknown initial character set index '255' received from server
Unknown initial character set index ‘255‘ received from server. Initial client character 解决方法
智十七的博客
03-22 2529
java.sql.SQLException: Unknown initial character set index ‘255’ received from server. Initial client character set can be forced via the ‘characterEncoding’ property.
【Spring JDBC】报错：java.sql.SQLException:Unknown initial character set index ‘255‘ received from server
懂得一千零一种,赋予你失败的方法！
03-02 706
在学习Spring JDBC的时候进行数据库表数据insert操作的时候，报错： java.sql.SQLException:Illegal connection port value@127.0.0.1: 3306' java.sql.SQLException:Unknown initial character set index '255' received from server 第一个报错后来检查，可能是url中包含的信息与配置中的重复，发生冲突，第二个报错是修改了配置中的url后，显示未知..
Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Unknown initial character set index '255'
06-01
这个错误通常是由于 JDBC 驱动程序无法识别数据库字符集引起的。这可能是由于以下原因之一导致的： 1. JDBC 驱动程序版本过旧，无法识别数据库字符集。 2. 数据库字符集设置不正确或不兼容 JDBC 驱动程序。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值