This isn't the place for it. However, I see you also posted it to the correct place: http://forum.hibernate.org
I recommend you go back to your Java documentation. Sun's Java documentation online has a possible solution for you but it requires the latest JDK (1.5): http://java.sun.com/docs/books/tutorial/i18n/text/collationintro.html Examples for this technique are here: http://java.sun.com/j2se/1.5.0/docs/api/java/text/Collator.html I think you'd probably want the getInstance with your country code call to set your locale appropriate (see the examples in that JavaDoc page). Regards, David -----Original Message----- From: Comain Chen [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 3:02 AM To: Struts Users Mailing List Subject: A question about hibernate query with special chracters Sorry to bother you all, but I really cannot find a better place to post this quesion. I am using Chinese in fact, so all character set is set to gb2312, and the jdbc connection is also properly set. Since if I hard code the query , it goes quite well. Like this, Session.createQuery(" from table1 where table1.name='问题'"); But when I am using binding parameters ,it cannot find any results. Like this, Session.createQuery("from table1 where table1.name=: name").setString("name","问题"); And if I do the same using english words, all works fine. Even with criteria, the problem still exists. Who can give me a hand, I am really pazzled now. Thanks in advance. -- Thanks for reading comain chen --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
