Thanks, but I think I still cannot get it. Yes, the Locale may have impact on string comparisons, but the comparison is done by hibernate not me. I just have to bind the parameter with a value.
So, I cannot even find a place to do my compraison using my own lagauage specific Colator. I have also tried to set the default locale to my language, and it still failes. Did I fully understand what you mean? More help is appreciated. 在 05-11-28，David G. Friedman<[EMAIL PROTECTED]> 写道： > 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] > > -- Thanks for reading comain chen
