Sorting and Comparing hinese and japanee Characters.

  • nata-1032882

    SSC Enthusiast

    Points: 179

    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....!

  • Gift Peddie

    SSC Guru

    Points: 73570

    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

  • nata-1032882

    SSC Enthusiast

    Points: 179

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

  • Gift Peddie

    SSC Guru

    Points: 73570

    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

  • nata-1032882

    SSC Enthusiast

    Points: 179

    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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply