I have a simple chinese application that it is currently using SQL2000 to host its database.   I am able to search in english, but I am not able to search in chinese.  I have change the Catalogs to Eastern Language.  Can someone tell me how can I setup my database to be able to search in english and chinese?

Thanks,

An obvious way to do it would be to use unicode and binary (AS CS) collation as this would be language-agnostic. I've never tried it with chinese but I'd have thought it would work. you can override the database collation for string comparisons for english where case is not important.