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.

HTH,
Set

--- In firebird-support@yahoogroups.com, "d_dude_2003" wrote:
> Hello,
> I created my FB 1.5 database with UNICODE_FSS charset.
> All varchar fields are created automatically with this charset as
> well. What else i need to ensure to have ORDER BY clause working
> properly for string field containing UNICODE?
>
> Also, will queries like WHERE UNICODEFIELD = UNICODEVALUE
> work?