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