[ajoysinha]

After configuring with J Connector driver , I am trying to connect to My SQL , but DB explorer is giving me the following error :

Unknown Character Set “usa7”

Please let me know how can I get read of it.

Thanks in advance

[Haris Peco]

ajoysinha ,

I suppose that you have non-default encoding in database

Try add encoding properties in URL, for example

jdbc:mysql://<YOUR_HOST>:<YOUR_PORT>/<YOUR_DATABASE>?useUnicode=true&characterEncoding=UTF-8

This is for UTF-8, but you can see complete syntax on

http://dev.mysql.com/doc/refman/4.1/en/cj-configuration-properties.html

Best regards
Peco

[Author]

Posts