Subject | Re: [firebird-support] Re: ORDER BY and Unicode field |
---|---|
Author | Helen Borrie |
Post date | 2004-04-14T12:25:28Z |
At 11:35 AM 14/04/2004 +0000, you wrote:
/heLen
>You definitely need to use a collation (COLLATE ...). Ordering mayYep, but UNICODE_FSS doesn't have any collations, Set...binary only.
>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.
/heLen