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


Riho-Rene Ellermaa
senior programmer
Hansabank

> -----Original Message-----
> From: Thomas Steinmaurer [mailto:ts@...]
> Sent: Tuesday, June 04, 2002 10:27 AM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] UPPER with accented characters
>
>
> Riho,
>
> having table in a database (WIN1252) like
>
> RECREATE TABLE TEST1 (
> ID NUMERIC( 18, 0) NOT NULL,
> NAME VARCHAR(40) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
> PRIMARY KEY (ID)
> );
>
> One record:
>
> ID NAME
> -------------------------------------------
> 1 äöü
>
>
> select upper(name) from test1
>
> gives me a result set of:
>
> UPPER
> ----------------------------------------
> ÄÖÜ
>
>
> Firebird v1.0 Final and connected with WIN1252
>
>