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.


No comments:

Post a Comment