Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Why "ä" and "Ä" (ü/Ü,ö/Ö) are different character

0 views
Skip to first unread message

Juraj Chovan

unread,
Feb 26, 2002, 5:56:40 AM2/26/02
to
Why "ä" and "Ä" (ü/Ü,ö/Ö) are different character
in SQL query:
SELECT UPPER(AnyStringColumn) FROM AnyTable
WHERE AnyStringColumn CONTAINING 'ä' ORDER BY AnyStringColumn ???

for example
- if I performed SQL query:
SELECT UPPER(AnyStringColumn) FROM AnyTable
WHERE AnyStringColumn CONTAINING 'g' ORDER BY AnyStringColumn ???
then query returned me every values which contains 'g' or 'G',
- but the same query with ...CONTAINING 'ä'
returned only values with 'ä' (not with 'Ä').

I have Interbase Server IBSERVER60
version: WI-T1.0.0.338 Firebird Beta2
and in BDE set LangDriver to: Borland DEU Latin-1.

Is any possibility that will be OK ? (setup anything in IB) ???

eero

unread,
Feb 26, 2002, 10:35:27 AM2/26/02
to
Hi,

it's probably matter of character sets.
You can write your query:


SELECT UPPER(AnyStringColumn) FROM AnyTable
WHERE AnyStringColumn CONTAINING 'ä'

OR AnyStringColumn CONTAINING 'Ä'
ORDER BY AnyStringColumn

or

SELECT UPPER(AnyStringColumn) FROM AnyTable
WHERE UPPER(AnyStringColumn) CONTAINING 'Ä'
ORDER BY AnyStringColumn

Eero

"Juraj Chovan" <Juraj....@florix.de> wrote in message
news:3c7b69ed_2@dnews...

Richard J Bibby

unread,
Feb 27, 2002, 10:14:07 AM2/27/02
to
Hej,

You can try the Use OEM/ANSI option if you are using ODBC.

Richard


"eero" <ee...@vesiir.ee> wrote in message news:3c7baae7_1@dnews...

0 new messages