Internationalization support in SQL Server 2005

Question

Internationalization support in SQL Server 2005

sharma-691993

SSCrazy

Points: 2194
More actions
April 11, 2008 at 11:50 pm

#379789

Hi i am using SQL Server 2005.
I want to insert Korean characters in a table.
NVARCHAR datatype supports unicode characters.
Is there is any settings to change in the server?
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jezemine SSCrazy Eights Points: 8059 More actions · Answer 1

nvarchar columns can take any unicode char.

the trick comes if you need to, for example, order by this column. In that case you need to specify a collation that makes sense for Korean.

---------------------------------------
elsasoft.org

sharma-691993 SSCrazy Points: 2194 More actions · Answer 2

Thanks for ur reply.

How to find the UNICODE for Korean characters and COLLATE for Korean?

while inserting a column i need to give Unicode for korean?

Is there is any change in settings to Server?

Regards

jezemine SSCrazy Eights Points: 8059 More actions · Answer 3

sivasenthilkumar (4/12/2008)
Thanks for ur reply.
How to find the UNICODE for Korean characters and COLLATE for Korean?
while inserting a column i need to give Unicode for korean?
Is there is any change in settings to Server?
Regards

you don't need to change anything on the server.

to insert, just do something like this:

insert mytable(mycol) select N'???'

when you create the table, specify a collation that you want to use when you order by that column. for example:

create table mytable(mycol nvarchar not null COLLATE Korean_Wansung_CI_AS)

here's a list of all the collations you could use:

http://msdn2.microsoft.com/en-us/library/ms180175.aspx

---------------------------------------
elsasoft.org

sharma-691993 SSCrazy Points: 2194 More actions · Answer 4

Thanks.

It is inserted in the database.

But still it shows like this symbol (???) in query result window.

When i am copying the text and paste it in the query window, it will display well.