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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-04-18 : 00:38:34
|
| Dear Friends, can you please tell me what exactly the definition of collation?thank you very muchVinod |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-18 : 00:44:40
|
Taken directly from SQL Server Books Online (the help documentation for SQL Server):quote:
Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales. For example, in an ORDER BY clause, an English speaker would expect the character string 'Chiapas' to come before 'Colima' in ascending order. But a Spanish speaker in Mexico might expect words beginning with 'Ch' to appear at the end of a list of words starting with 'C'. Collations dictate these kinds of sorting and comparison rules. The Latin_1 General collation will sort 'Chiapas' before 'Colima' in an ORDER BY ASC clause, while the Traditional_Spanish collation will sort 'Chiapas' after 'Colima'.
Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
collation definitio