Charset issues

bluetrade · **Joined:** Sun Jun 25, 2006 9:27 pm **Posts:** 18

Hi,
I have some problems with hibernate when trying to use a "String" as my primary key. I am using mysql 5.0.37. I have a collection which is persisted at some point in time and which I scan for duplicates in java. However, hibernate still throws me an exception, treating "Bjorn" the same as "Björn" for example. I have played around with charsets but I cannot get it to work - I get an error like this:
Duplicate entry 'BjÃ¶rn Borg' for key 1

Thanks for your help!

max · **Posted:** Wed Apr 25, 2007 3:38 am

thats your database, not hibernate that is complaining.

bluetrade · **Joined:** Sun Jun 25, 2006 9:27 pm **Posts:** 18

hi,
thanks for your answer max, however, the database supports a feature that allows to store the value in a varchar as a "binary" value rather than a character-sequence. How can I achieve this with hibernate?
thanks!

max · **Posted:** Wed Apr 25, 2007 6:22 pm

how would you do it in jdbc?

bluetrade · **Joined:** Sun Jun 25, 2006 9:27 pm **Posts:** 18

I got it to work with:
@Id @Column(columnDefinition=" varbinary(255) NOT NULL")

While I get less errors now, I still have troubles with duplicate key exceptions... is there a way to just go ahead and leave out the entries of a set that are also merged (due to cascading) and are problematic instead of rejecting the entire transaction?

Thanks!

max · **Posted:** Thu Apr 26, 2007 1:02 pm

no, why should we ignore inconsistent data errors ?

bluetrade · **Joined:** Sun Jun 25, 2006 9:27 pm **Posts:** 18

yes, I guess you're right. I just don't need to have such a high accuracy, so I will just try and catch and go on...

thanks, though!

max · **Posted:** Thu Apr 26, 2007 1:58 pm

catching exceptions and ignoring them will leave your state "undefined" ...that can't be what you want.

bluetrade · **Joined:** Sun Jun 25, 2006 9:27 pm **Posts:** 18

thanks max!
you're right, but I don't really see a way around this right now. I finally managed to resolve the locale-errors by setting my system locale to UTF-8. Now I am fighting with a last issue that throws exceptions, I opened a separate post for that, regarding different issues with duplicates!
again, thanks a bunch for your help & advise!