How to specify MySQL Server Character Set

[Former Member]

Hi all,

I need to obtain data from a MySQL Server and I don't know how to specify the character set. I need to use UTF-8 encoding when retrieving the results of my queries. Should I fill "InitCommand" parameter in IDBC Server Parameters when defining the Data Server? Maybe should I specify the character set in ServerURL?

Thanks.

Regards.

[jcgood25]

Have you tried adding it to the end of the ServerURL?

http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-charsets.html