what does it mean - COLLATE Cyrillic_General_CI_AI ?

Question

Hi all,

What does it mean - COLLATE Cyrillic_General_CI_AI ? I know it's codepage of column... I guess each of parts (Cyrillic, General, CI, AI) means something, where do I find details?

 

Answer 1

http://msdn.microsoft.com/en-us/library/ms144250.aspx

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

Hi,

It defines the sorting as well as AI: accent insensitive, CI: case insensitive. Please take a look on the BOL article about Collations: http://msdn.microsoft.com/en-us/library/ms143503.aspx

I hope it helps.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.
My Blog