Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sorting and Comparing hinese and japanee Characters. Expand / Collapse
Author
Message
Posted Thursday, March 26, 2009 1:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 03, 2009 9:32 PM
Points: 9, Visits: 39
We 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 configurations

But, 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.


Thanks in advance....!
Post #683871
Posted Thursday, March 26, 2009 7:41 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
You need to do text encoding in Java and use the correct collation for each version of Chinese, Japanese, German, French and English. So in Java you text encode and in SQL Server you use collation.

http://java.sun.com/docs/books/tutorial/i18n/text/stream.html

http://msdn.microsoft.com/en-us/library/ms143508.aspx

http://msdn.microsoft.com/en-us/library/ms144250.aspx


Kind regards,
Gift Peddie
Post #684740
Posted Monday, March 30, 2009 5:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 03, 2009 9:32 PM
Points: 9, Visits: 39
The exact thing is I need to Use a Single Collation, so that it has to satisfy all the languages.
I had already Text encoded in java, the problem only with Sql Collation.

I tried using Japanese_Unicode_CI_AS Collation, it is comparing Japanese, Dutch, German, Italy and English,but not supporting Chinese(Simplified, Traditional),Spanish and French.

Please help me.....

Thanks in Advance...
Post #685974
Posted Monday, March 30, 2009 6:40 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
I don't understand why you would need something that is not technically viable because Japanese and Chinese alphabet is more than 2500 characters while all the other languages uses the latin alphabet at the very least you need two collation but I actually think you need a separate collation for all languages.



Kind regards,
Gift Peddie
Post #686027
Posted Wednesday, April 01, 2009 1:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 03, 2009 9:32 PM
Points: 9, Visits: 39
hi.....I tried using Chinese_PRC_CI_AS collation , it is now comparing all the languages i.e; Chinese(Simple and traditional), Japanese, Dutch, Spanish, German, Italian, French.

This is the Collation which is working for all languages in a single DB
Post #687687
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse