Subject Re: Problem with COLLATE EN_UK
Author artlooksoftware
My experience beyond English is in Spanish where accented characters
must be sorted as if unaccented, eg Tarifa, Tárifa, Tarragona - the
EN_US sort puts all the accented characters at the end and I think in
their ascii value order.

I understand your hidden field concept and indeed already use it, but
not on this field. I don't want to have to do it for every field the
end user might fancy sorting on!

--- In, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:
> --- 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
> HTH,
> Set
> 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 æ, ø, å).