For Example.,
Database created (with Chinese Collation) for an application to handle chinese
data. Database created (with Korean Collation) to store Korean data.
Another Database created (With Latin) to handle english data.
All these regional data are consolidated in central repository sql server.
on quering the data..chinese, korean data are in junk characters. Pls advise how to handle these issues.
How to store & retrieve mulilingual data from sql server
Is there any Collation that handles all the characters. Thx