MySQL 5.0 Connection Error: Unknown initial character set index '48' r

Anonymous — Sat, 16 Nov 2024 14:37:22 GMT

As I just observed this connection issue (actually a mysql-bug / config issue) I'd like to share it including solution;
regards gk
On connecting from Talend Studio to mysql 5.0.27 the following Error is received:
Unknown initial character set index '48' received from server.
Initial character set can be forced via the 'characterEncoding' property.
used:
MySQL Version: 5.0.27
W2K SP4
Talend Error:
Starting job tDBInput at 19:36 22/03/2007.
Running process with context: Default
Exception in component tDBInput_1
java.sql.SQLException: Unknown initial character set index '48' received from server. Initial client character set can be forced via the 'characterEncoding' property.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2345)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3913)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2683)
at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at talenddemosjava.tdbinput.tDBInput.tDBInput_1Process(tDBInput.java:146)
at talenddemosjava.tdbinput.tDBInput.main(tDBInput.java:326)
Job tDBInput ended at 19:36 22/03/2007.

Solution:
In your my.cnf (nix) or my.ini (win) in the section

modify the following encoding parameters:
### old:
# character-set-server = latin1
# collation-server = latin1_general_ci
### new
character-set-server = utf8
collation-server = utf8_bin
See also http://bugs.mysql.com/bug.php?id=23645

topic MySQL 5.0 Connection Error: Unknown initial character set index '48' r in Installing and Upgrading

MySQL 5.0 Connection Error: Unknown initial character set index '48' r