Sorting and Comparing hinese and japanee Characters.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Globalization » Sorting and Comparing hinese and japanee...

Sorting and Comparing hinese and japanee Characters.

Rate Topic

Display Mode

Topic Options

Author

Message

nata-1032882

Posted Thursday, March 26, 2009 1:10 AM

Forum 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

Gift Peddie

Posted Thursday, March 26, 2009 7:41 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

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

nata-1032882

Posted Monday, March 30, 2009 5:24 AM

Forum 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

Gift Peddie

Posted Monday, March 30, 2009 6:40 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

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

nata-1032882

Posted Wednesday, April 01, 2009 1:45 AM

Forum 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 »

Permissions