Subject Re: Problem with COLLATE EN_UK
Author Svein Erling Tysvær
--- In, "artlooksoftware" wrote:
> Is this a bug or am I misunderstanding something? Sort is correct
> with EN_US, but then foreign names with accented characters are
> wrongly sorted.

According to your opinion, what is the correct sorting of accented
characters? If it is the same as non-accented, then you could use the
old trick to have an extra column that contains the non-accented
equivalent (the old trick is to have an uppercased field, so that 'a'
and 'A' are equivalent). Populate this field through triggers and run
queries like:

select Name from ATABLE order by UnAccentedName


PS! Being Norwegian, I know that å, ä and ö is not to be considered
accented characters in Scandinavian languages, they are separate
vowels at the end of the alphabeth (Swedes sort them å, ä, ö,
Norwegians and Danes ä, ö, å - though we normally write them æ, ø, å).