Hi,

> 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)='ÄÜ'

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

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

Is it possible to add collation order to stored procedure result columns?

Best regards,
Vadim