At 09:46 AM 23/06/2003 +0000, you wrote:

>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?

select c from t where UPPER(c) = UPPER( _ISO8859_1 'Füße');

i.e. prefix your characterset id with an underscore.

heLen