Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017Chinese Data Japanese Korean requirement SQL Server store

0

Posted

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

1 Answer

0

Posted

Location: http://www.jguru.com/faq/view.jsp?EID=114155 Created: Jul 29, 2000 Modified: 2000-07-29 13:48:07.302 Author: Joe Sam Shirah (http://www.jguru.com/guru/viewbio.jsp?EID=42100) Question originally posed by Mohammed Khadeer Ahmed (http://www.jguru.com/guru/viewbio.jsp?EID=111146 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.