쓰시는 곳에서 한글이 똑바로 안보입니다.

그냥 영어로 질문하세요 그래야 알아볼 수 있을 것 같습니다.

I've never used Hangeul database before, so somebody help me   that what have I done wrong for the below steps :

For my testing purpose, I created the database with the collation name of Korean_Wansung_CS_AS and created the testing table, say, Test1 with "id" column (int), and "description" (varchar(1000)) column.

I made some testing program using ASP.NET with VB.NET with Visual Studio.NET 2003. And I inserted some Hangeul value into this table.

When I see the value from the Query Analyzer, the Hangeul value that I inserted was broken. Same thing happened if I see it from the Browser.

Can you tell me what steps did I missing to make it correctly working?

In order to insert and retrieve the Hangeul value, how do you guys do in Korea?

 Thank you in advance.

You use 'nvarchar' data type that define "description" column.

Create table test

(

    id int

    ,description   nvarchar(500) -- nvarchar =>unicode datatype

) ;