Korean language not displaying

Question

User-1471881183 posted

hi all,

in my web application i have added some korean text to my SQL database(NText column) and retrieving the same to the web page but its displaying like(all blobs) this

팀에 합류했다. 회사는 독립적인 플롯에 3 층 공장을 구축하여 자사의 용량을 증가시켰습니다. 회사는 정밀 부품 및 산업용 밸브 제조 업체로서의 작업을 계속했다. 지금은 시간이 Mistry 산업은 그 모양을 이유지. 회사의 경영은 훌륭한

how i have added this content into db is, i have paste the content to the HTML Editor from there store the content to the Table(Ntext column)

how to solve this issue?

Answer 1

User-1802908944 posted

read here

http://msdn.microsoft.com/es-es/library/system.globalization.cultureinfo.aspx

Answer 2

User-1471881183 posted

nareshguree23 thanks for your response, but thats not gave me a solution.

Answer 3

User-1200560727 posted

Hi,

Please check below section in your web.config:

<globalization fileEncoding="utf-8" requestEncoding="utf-8"  responseEncoding="utf-8"  culture="ko-KR" uiCulture="ko-KR" />    

Below posts will helpful to solve your problem:

http://forums.asp.net/t/1560929.aspx

http://forums.asp.net/t/1561722.aspx

 

Regards,

Tapan

Answer 4

User78336405 posted

Hi,

Try to change SQL Collation to: Korean_90_CI_As. 

Answer 5

User-1802908944 posted

use Collation Name Korean_Wansung_CI_AS

read here

http://www.sqldev.org/sql-server-database-engine/korean-language-not-displayed-correctly-89157.shtml

http://blogs.msdn.com/b/qingsongyao/archive/2009/04/10/sql-server-and-utf-8-encoding-1-true-or-false.aspx