michal.720 wrote:

> Hello,
>
> I have a table "users" and I want to store "name_first" and "name_last"
> in many languages. I have a table "task_types" with column "name" in
> many languages.. And so on...
>
> So I have to use charset UNICODE_FSS. But there is only one COLLATION
> for UNICODE_FSS.
>
> How can I solve this problem, when I need to sort one column in
> different collations?

This is an area that is being actively worked on in Firebird itself.
Until that work is finished as you say - there is only one collation for
UNICODE_FSS
A case at present of 'Watch this Space'

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services