michal.720 wrote:

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

We are getting some useful tips tonight ( well it's night here ).
The data archive I had started to create has geographic names from many
languages, but sorting the lists had been a niggle. If I produce a table
of collations against country/region then I can select the right one for
each list.

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