|Subject||RE: [ib-support] UPPER with accented characters|
Thanks, that almost works: ÄOÖÜ instead of OÄÖÜ, but one cannot be choosy :)
> > 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
> Thomas Steinmaurer
> IB LogManager 2.0 - The Logging/Auditing Tool for Interbase
> and Firebird