Hibernate --> MySQL: character encoding

javatwo · **Joined:** Tue Sep 13, 2005 2:01 am **Posts:** 137

A J2EE web application using JBoss 4.0.3SP1 with Hibernate on Window XP.

DB: MySQL 4.1, UTF8.

Client need to tell MySQL the following things:
Character-set-client, Character-set-connection,
Character-set-results

How to config Hibernate to use UTF8 to communicate with MySQL?

Thanks.

emmanuel · **Posted:** Wed Feb 08, 2006 2:14 pm

through the JDBC properties.

javatwo · **Joined:** Tue Sep 13, 2005 2:01 am **Posts:** 137

emmanuel wrote:

through the JDBC properties.

where are the JDBC properties? Thanks for help.

emmanuel · **Posted:** Fri Feb 10, 2006 7:16 am

That's not the first time I see you asking questions clearly stated in the documentation.
Please read twice
http://www.hibernate.org/hib_docs/v3/reference/en/html_single/
http://www.hibernate.org/hib_docs/annotations/reference/en/html_single/

timvw · **Posted:** Fri Feb 10, 2006 4:26 pm

Overhere it would look like (But as emmanuel already said, a simple websearch for mysql, jdbc, utf-8 returns everything you need to know)

Code:

jdbc:mysql://my.example.com:3306/mydatabase?useOldUTF8Behavior=true&useUnicode=true&characterEncoding=UTF-8