Determining details of sort order in a collation
Posted on 2006-11-10
I'm using collation Finnish_Swedish_CI_AS in a database.
I note that (for instance) V and W are considered equal in this sorting, which surprises me (and possibly all other swedish people, at least the computer-firendly ones:-)
Also, I note that the sorting of danish Ö (o-umlaut) is not sorted together with swedish Ö -- etc etc. Also, there is (of course) a specific sort order of all (as an example) accented "A" characters, and I'd like to know exactly which order it is.
I've tested a little by creating a table with all possible character values, and then checked the sorted output.
However, is there any way to exactly determine the specific details of a collation sort order?
Something like "help_collation 'collation_name'" or "SELECT * FROM ::fn_helpcollations_details()" or something similar?
What I'm looking for is a way to explain to people exactly how each character is sorted.
Also, SQL Server is using Windows collation, right? Perhaps one could get this kind of list somewhere from Windows instead?