Subject | National characters |
---|---|
Author | Jacek Borowski |
Post date | 2005-07-26T15:27:50Z |
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.
Regards,
Jacek Borowski
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.
Regards,
Jacek Borowski