Peter wrote:
<
Testing with isql for Firebird 1.03, running with
set names DOS437

Given the DDL:
create table t (c char(30) character set ISO8859_1 collate de_de);

Then the statements:
insert into t values ('Füße');
select c from t where UPPER(c) = UPPER('Füße');

No row will be selected, because UPPER(c) uppercases
'ü' to 'Ü', whereas UPPER('Füße') doesn't.

Is there a way to specify which UPPER should be called for
UPPER('Füße'), so that the expected result can be achieved?

>

IIRC,
select c from t where UPPER(c collate de_de) = UPPER('Füße' collate de_de)


--
Aage J.