I have a requirement to store Chinese, Japanese, Korean and more data in SQL Server. How?

Joe Sam Shirah

Most database engines support double byte character sets ( DBCS ) and this was the primary method of supporting these languages in the past. While this is generally still available, Unicode is probably a better answer now, along with some efficiency gain in Java.

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.