I want to know if it's possible to set the database encoding to use with Hibernate within an application.
It's for sorting String literals in alphabetical order depending of the country language.
Thanks a lot.

just set it as you would do in any other jdbc application.

In any other jdbc application I can put something like:

Locale LOC = new Locale("ES", "es");
Locale.setDefault(LOC);

but with Hibernate, i have not the control of the Connection. Hibernate manages it with the values set in the hibernate.cfg.xml.

you did not touch the connection in that code....so why dont you just setup that code before you call hibernate ?

or simply provide your own connection provider if you want some specific done to your connection.

OK!!
I have done it and it works. Sometimes the right answer is the easiest.
Thanks.