Hello Vadim,

d> The problem is that this query isn't working properly in case the user
d> wants to filter on German specific letters (Umlauts):
d> SELECT * FROM MY_STORED_PRC(...) WHERE UPPER(COL1)='ÄÜ'
d> The result of this query is empty, but it should be not empty because the
d> stored procedure's result includes the line "äü" for example.

d> After some experiments I've found that if I change stored procedure to
d> return the data in uppercase, then the query works properly.
d> But this solution isn't good for us, because I have to return tha data
d> from the database in usual case (not upper case).

d> Could you please give me some advice on this problem?
Yes. I suppose you didn't specify collation for your COL1 column, so
FB uses the default one. I think the use of stuff like
COL1 character set ISO8859_1 collation DE_DE
will solve the problem.



HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com