Subject How to specify which UPPER() to be called
Author peter_jacobi.rm
Testing with isql for Firebird 1.03, running with
SQL> set names DOS437

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

Then the statements:
SQL> insert into t values ('Füße');
SQL> 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?

Peter Jacobi
Hamburg, Germany