«
»

UTF-8 with Hibernate 3.0 and MySQL

Hi again, I’m now tackling something I’ve been meaning to do for ages (and probably should have done before I started the project) and that is to use Hibernate rather than rolling my own SQL.

I’m reading the book “Hibernate in Action” by Christian Bauer and Gavin King and have been trying it out. The book relates to Hibernate 2.0 and 2.1 so doesn’t include annotations which is a bit of a shame, but it’s still a good start.

Unfortunately as readers of this blog will know, I’m trying to put UTF-8 strings into the database so you can imagine my disappointment when I saw the familiar question marks appearing where there should be interesting new characters.

The fix turned out to be not so difficult to find however, thanks to Philip Whirlycott’s blog posting More UTF-8 head-thumping with Hibernate 3 (obviously I’m not the only one struggling with these issues).

With Hibernate 3 (maybe not with 2.1, I’m not sure), you need to add some extra connection parameters:

jdbc:mysql://localhost/mydb?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8

If you put this in your hibernate.cfg.xml file for the JDBC URL it works and you can save the UTF-8 correctly.

Tags: , , ,

This entry was posted on Friday, January 12th, 2007 at 1:35 pm by DenisH and is filed under Blog Entries, Java, Persistence. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

8 Responses to “UTF-8 with Hibernate 3.0 and MySQL”

  1. Michael Bar-Sinai says:
    May 26, 2007 at 4:37 pm

    Thanks for this useful post – I had the same problem and didn’t know what to do.

    One update for using JPA: not all the parameters are needed and they cause an exception while hibernate tries to parse the persistence.xml file. For me, the following work fine (for hebrew):

    <property name=”hibernate.connection.url” value=”jdbc:mysql://localhost/second_homes?characterEncoding=UTF-8″/>

    Reply
  2. Michael Bar-Sinai says:
    May 26, 2007 at 4:41 pm

    jdbc:mysql://localhost/mydb?characterEncoding=UTF-8

    Reply
  3. BISOِ says:
    March 6, 2008 at 8:40 am

    Thanks a lot, you post where very helpfull

    BISO

    Reply
  4. Leonardo Pinheiro says:
    November 6, 2008 at 7:21 pm

    Thanks for your suggestion, I’ll use that with Grails.

    Reply
  5. UTF-8 mit Hibernate und MySQL « shaack´s Technik-Weblog says:
    November 23, 2009 at 1:50 pm

    [...] Gefunden auf: http://www.isocra.com/2007/01/utf-8-with-hibernate-30-and-mysql/ [...]

    Reply
  6. shawary says:
    May 3, 2010 at 6:57 am

    thanks a lot for your post …. i steel has this problem . i am using hibernate3 with spring and jdbc:mysql://localhost/mydb?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 dose not work 4 me please advice.

    Reply
  7. moien says:
    July 9, 2010 at 6:52 am

    thanx for thiss usefull note.
    but i still have a problem inserting persian characters

    Hibernate: insert into Stocks (symbol, corpName, maxPrice, minPrice, lastPrice, finishedPrice, yesterdayPrice, changed, percent, bestRequest, bestOffer) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    765 [main] WARN org.hibernate.util.JDBCExceptionReporter – SQL Error: 1366, SQLState: HY000
    765 [main] ERROR org.hibernate.util.JDBCExceptionReporter – Incorrect string value: ‘\xD8\xB4\xD8\xA7\xD8\xB1…’ for column ’symbol’

    Reply
  8. moien says:
    July 9, 2010 at 8:34 am

    SOLVED!
    i just had to drop the db and create it again with new unicode collation

    Reply

Leave a Reply