Hello Vadim,

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

d> I have no idea how to specify collation order for the stored procedure
d> result columns.
d> I've tried to add the stored procedure with the result column as
d> "COL1 character set ISO8859_1 collation DE_DE" or
d> "COL1 character set ISO8859_1 collate DE_DE", but I receive
d> the error message "Token unknown".

d> Is it possible to add collation order to stored procedure result columns?
Sorry, it was the decission for tables. For stored procedures you
could try
SELECT * FROM MY_STORED_PRC(...)
WHERE UPPER(COL1 collation DE_DE) = 'ÄÜ'


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