Jacek Borowski wrote:

> Hi,
> Firebird 1.5.2
> From trigger I need to:
> select ccc,ddd from procedure(new.eee,new.fff) where something....
> In procedure(aaa varchar(100),bbb varchar(100))
> i need convert aaa to upper(aaa) and it doesn't convert national characters
> to upper.
> when I changed select ccc,ddd from procedure(upper(new.eee) ,new.fff) where
> something.... it works fine.
> Database has default code page set to WIN1250, field 'eee' is set explicit
> to WIN1250
> I tested procedure(aaa varchar(100) character set WIN1250 ,bbb varchar(100)
> character set WIN1250 ) but it doesn't works too.
> Any suggestions, please.

I haven't used WIN1250, but the general idea is to specify a collation.
An example from my IDS8859_1 database (which may be garbled through the
newsreaders):
select upper('aæøåx'), upper('aæøåx' collate no_no)
from rdb$database
produces (correctly)
AæøåX AÆØÅX


--
Aage J.