I made a workaround for storing data in Unicode and sorting in any
collation...

Part of query. It works fine :-)

ORDER BY
CAST ("U"."name_last" AS VARCHAR(200) CHARACTER SET WIN1250)
COLLATE PXW_CSY


For multi-language application it's possible to
- define default charset and collation for all languages used in application
- and then use PHP to compose query like this one.

Michal


Lester Caine wrote:

>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'
>
>
>