Data Storing Problem......

Hi everyone,

I have some data which is in korean Language and i want to store that data in sql server 2000 table's row.But i am not able to store it.

When i try to store it then it display me square box in table.

Does anybody have any idea about this matter?

Plz reply me back as soon as possible.

Thanks

---Nimesh Patel

Please check out Books On Line for SQL Collations. Setting the collation level allows you to store data in different languagues.|||

Collations have nothing to do with what you can or can't store. Collations are the rules that define the order of alphabets, which is important for sorting.

Are the columns that you are storing the data into defined as nvarchar, nchar, or ntext?

After pulling out the data from the database, are you displaying it in a font that actually has those characters?

||| I think I need to check out the BOL first. thanks for the correction Motley and good to see you back. Its been kinda dull here lately..|||Good to see you are still around as well ;-)|||Yes.. been fighting the battle all alone|||You've never been alone, you've just been doing such a great job that I rarely have to say anything anymore