InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 18:49:56 GMT20http://www.sqlservercentral.com/Forums/Topic689721-230-1.aspxduplicate post.(actually quaduplicate!)no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.the "Recent Posts" link shows us everything.continue the thread here:[b][url=http://www.sqlservercentral.com/Forums/Topic689728-230-1.aspx]http://www.sqlservercentral.com/Forums/Topic689728-230-1.aspx [/url][/b]Fri, 03 Apr 2009 06:14:13 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic689721-230-1.aspxWe are developing a J2EE application using Struts + Tomcat Server+ Session Beans + MS SQL 2005 Data Base and our application is expected to be a multi-lingual. We are able to accept and display chinese and japanese characters by using the proper charset in JSP - and other configurationsBut, when we are doing a search, we are not able to sort and compare them. Our application has both simplified and traditional chinese characters and japanese characters. I have tried to sort them using collator class. Still, it is not meeting our requirement.Please let me know how do we sort and compare them.Is it necessary we need to use SQL Collation.Please Help!!! as i am new to this.Fri, 03 Apr 2009 04:45:08 GMTnata-1032882