Using collation for international languag other than English

Question

The SQL 2005 server has "SQL_Latin1_General_CP1_CI_AS" as default collation to have english characters.
I am trying to input "Korean" language into the database, and then now I see funny "???" character after I insert a data.

What is my option to use Korean character on my database?
Should I create whole new database?

Thanks.

Answer 1

You can change the database collation, see this link : http://msdn.microsoft.com/en-us/library/ms174269.aspx . You can also change collation at column level : http://msdn.microsoft.com/en-us/library/ms190920%28SQL.90%29.aspx

Hope this helps

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

I did changed the collation of the table but it still shows me "???" when I insert a data as Korean.

Server : SQL 2005 standard

1. This is what I did.

ALTER TABLE EVA_MAIN_QUESTION ALTER COLUMN CATEGORY_NM
            varchar(100)COLLATE Korean_Wansung_CI_AS

2. Should I add something when Insert or update is exucuted?

3. What is the unicode collation?

Thanks.

Answer 3

I found the answer to use Unicode languge.

1.  Keep the current collation

2. change the datatype of the column or table by nchar or nvachar for unicode from char or varchar

3. When you update or insert, Put N(upper case) from the ther data.

 (ex) Update Mytable
              set TheColumn = N'abcd'
          where ThisCoulm = 1001

Then the database takes the unicode language.