Peter,

> 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('FьЯe' collate de_de);


Dmitry