Subject RE: [ib-support] UPPER with accented characters
Author Thomas Steinmaurer
> 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

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

Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for Interbase and Firebird