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

Regards,
Thomas Steinmaurer
http://www.iblogmanager.com

> -----Original Message-----
> From: Riho-Rene Ellermaa [mailto:r.ellermaa@...]
> Sent: Tuesday, June 04, 2002 9:16 AM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] UPPER with accented characters
>
>
> The sorting order is:
> PXW_INTL850: aäbcuüoo - accentes are ripped of
> PXW_SWEDFIN: abcdootuväü - only o with tilde is sorted incorrectly
>
> The UPPER function doesn't work in either case
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
> > -----Original Message-----
> > From: Thomas Steinmaurer [mailto:ts@...]
> > Sent: Monday, June 03, 2002 11:44 AM
> > To: ib-support@yahoogroups.com
> > Subject: RE: [ib-support] UPPER with accented characters
> >
> >
> > Try to use another one. For example PXW_INTL850. I've done
> > some research
> > one year ago, playing with character sets/collations
> > ISO8859_1/DE_DE and
> > WIN1252/PXW_INTL850. UPPER() of umlauts with WIN1252/PXW_INTL850
> > works well.
> >
> > HTH,
> > Thomas Steinmaurer
> > IB LogManager 2.0 - The Logging/Auditing Tool for Interbase
> > and Firebird
> > http://www.iblogmanager.com
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>