Thursday, August 28, 2008
DBVisualizer, MySQL 'characterEncoding' error
While connecting to MySQL server using DBVisualizer 6.0.9, there was an error message;
An error occurred while establishing the connection:
Type: java.sql.SQLException Error Code: 0 SQL State: S1000
Message:
Unknown initial character set index '192' received from server. Initial client character set can be forced via the 'characterEncoding' property.
So I tried to upgrade my DBVisualizer to version 6.0.13 but it does not solved the problem. After some googling session, here is my solution/workaround. Reffering to the error message, I open the connection properties tab and find 'characterEncoding' property. So now what to fill it with? I login to my webhosting CPanel > 'phpMyAdmin' and try to look for some clue.
Found it!
Set it in and ready to go.
Subscribe to:
Post Comments
(
Atom
)
Posts
No comments :
Post a Comment