annotations sorting collate

ales · **Joined:** Tue Sep 13, 2005 4:10 pm **Posts:** 2

Hi all,
I am using Hibernate 3 along with the Hibernate Annotations. Ordering in my application does not work correctly because data stored in the database are in the Slovak language. IMHO I need to specify at property definition in a POJO class something like COLLATE 'skSK'. But I do not know how. This is possible and works very well at column definition in a Hibernate mapping file. Thanks for any help or clue.

Ales

emmanuel · **Posted:** Tue Sep 13, 2005 7:11 pm

you mean order by at the DB level? You should check your JDBC configuration properties.

ales · **Joined:** Tue Sep 13, 2005 4:10 pm **Posts:** 2

Yes, you have right. My problem should be solved outside of the Hibernate and Hibernate Annotations. Thank you for clue.

Ales

JavaSchorsch · **Joined:** Tue Oct 18, 2005 11:22 am **Posts:** 14

ales wrote:

IMHO I need to specify at property definition in a POJO class something like COLLATE 'skSK'. [...] This is possible and works very well at column definition in a Hibernate mapping file.

So it seems to work with a Hibernate mapping file!? But how?

I have the same problem with German Umlauts, but I didn't find any xml-attribute "collate" for the collection-elements.

There's only the "order-by"-attribute.

What I want, is something like:

Code:

<bag name="children" inverse="true" cascade="all-delete-orphan" order-by="name" collate="latin1_german2_ci">
    <key column="parentId"/>
    <one-to-many class="Child"/>
</bag>

Btw, does anybody know, wether HSQLDB supports such collation-stuff and where I can find a list of all available collate-charactersets?

TIA,
Schorsch