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

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