Subject Re: [firebird-support] Re: ORDER BY and Unicode field
Author Daniel Rail
Hi,

At April 14, 2004, 08:35, Svein Erling wrote:

> You definitely need to use a collation (COLLATE ...). Ordering may
> actually vary between various collations. E.g. Norwegian and Swedish
> have 3 additional characters - they are normally written a bit
> differently, but are basically the same characters. However, the
> Swedes have never understood the proper way to sort them, hence their
> alphabet is incorrectly ordered ;o) I assume the same is true for
> other languages as well.

But, with UNICODE_FSS, there's only one collation: UNICODE_FSS.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)