Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Collation In Sql server

Author  Topic 

rdgopinath
Starting Member

1 Post

Posted - 2006-09-20 : 05:16:16
Hi All,

I created one table 'test' with the field 'cname'[ datatype :ntext]
and tried to insert a row given below into the table

INSERT INTO TEST VALUES(N'après-ski')

The query executed sucessfully. But my question is what is the use of collation? when is it useful?

I will be glad if you explain it with real example.

Thanks in advance

gopinath

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-20 : 05:38:24
Check out following links:

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da_1pwz.asp[/url]

Also check this PPT (simple and nice):

[url]http://www.unicode.org/iuc/iuc18/papers/b3.ppt[/url]

Also check Collation in SQL Server Books online...there is lot of information on it!

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page
   

- Advertisement -