> Yes, in Firebird it works. I tested it at home with IB6.01 (have
> to recheck it just in case)
>
> BUT... the sorting order is not usable
> AÄBCMNOÖOPRSTUÜ - accentes are ignored
>
> I need ABCDEF...TUVOÄÖÜXY

Hmm, ok this is your definition for sorting. For German AÄBCM is suitable,
because Ä is interpreted as AE and so it is before B. The same sorting
order is used in a German dictionary.

I don't know if there is a character set/collation combination, which really
fulfill your needs. One thing you could do though.

select upper(your_pxw_intl850_field) from yourtable order by 1 collate
win1252

Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for Interbase and Firebird
http://www.iblogmanager.com