Things like this are easily found using the define:collation search in Google. Check out the Wikipedia entry on <a href="http://en.wikipedia.org/wiki/Collation">collation</a>
Collation is simply the character set and ordering rules with the database uses. For example the Collation Greek_CI_AI uses the Greek alphabet, with case insensitivity, and accent insensitivity. What this means is that case is not taken into account when sorting data, and accents are not taken into account when sorting data. This also means that when deciding if the data is unique or not case and accents will not be taken into account.
Last Wiki Answer Submitted: May 22, 2008 3:58 pm by Labnuke9932,645 pts.
All Answer Wiki Contributors: Labnuke9932,645 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.