Hi Hibernate users,

I'm new to Hibernate. I use it in the persistance layer of a little webapp.

I have a problem with queries that have special characters (é,à,...) in the 'where' clause. I imagine it's an encoding problem.

For example, if I write and log the following hibernate query:



Then, when I put show_sql to true, I get the following query in the logs:



I don't understand why Hibernate don't reproduce the same characters in the sql query. Where could I tell Hibernate what encoding to use? Is the previous question weak?

Thank you for your help.

argh, it works on windows. I think I have a problem with encoding on my linux platform. The problem is not only related to hibernate.

After having debugged until antlr processing, I exposed my problem on another forum.Someone gave me a clue: 'Are the special characters in the parameters of your HQL request?'. Well, parameter? Oh my god, I don't use setParameter(), setDate(), etc. The 'where" clauses were written like SQL.

Then I re-wrote my 'where' clause constructor using hibernate API methods, and now it works.