I have a requirement to store Chinese, Japanese, Korean and more data in SQL Server. How?
For SQL Server specifically, one can use the nchar, nvarchar and ntext types to support Unicode. See Using Unicode Data for an overview. For more information, see: Where can I find online documentation for database xyz?, along with Unicode related questions in the FAQ.