The Latin_1 General collation will sort 'Chiapas' before 'Colima' in an ORDER BY ASC clause, whereas the Traditional_Spanish collation will sort 'Chiapas' after 'Colima'." Collations dictate these kinds of sorting and comparison rules. However, a Spanish speaker in Mexico might expect words beginning with 'Ch' to appear at the end of a list of words starting with 'C'. For example, in an ORDER BY clause, an English speaker would expect the character string 'Chiapas' to come before 'Colima' in ascending order. "Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales. Before moving ahead, let's discuss what the collation setting is used for as per books online
0 Comments
Leave a Reply. |