| Subject | RE: [ib-support] UPPER with accented characters |
|---|---|
| Author | Riho-Rene Ellermaa |
| Post date | 2002-06-04T07:16:06Z |
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
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