Hello SET,

SET> We generally use ISO8859_1 as our character set. Connected to one
SET> database with that character set I tried:

SET> SELECT UPPER('æøå') FROM rdb$database

SET> and it returned 'æøå'.

Because that's just a string for FB.


SET> Adding a bit:

SET> SELECT UPPER('æøå' COLLATE NO_NO) FROM rdb$database

SET> returned 'ÆØÅ'.

SET> I have no experience in changing character set, so others will answer
SET> this part.

You may try

SELECT UPPER(_iso8859_1 'your_lowered_str' COLLATE NO_NO) FROM rdb$database

to let FB know, which character set and collation you want with this
particular string.



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