At 08:11 PM 21/12/2007, you wrote:

>Hi Tom,
>I tried your suggestion, but with the same result.
>This time (with IBExpert) before the error message was displayed, I've
>got a couple of rows...
>
>--- In firebird-support@yahoogroups.com, "tomkrej" <respektive@...> wrote:
>>
>> hi, try select upper(cast (denumire as varchar(30) character set
>> UNICODE_FSS) )

UNICODE_FSS doesn't have upper-lower mappings except for the equivalents for the 7-bit ASCII character set. What's happening here is that, at the third row, you have a higher-order character for which the engine cannot establish an uppercase mapping and you get a transliteration error.

Tip: since Fb 2 provides UTF8 options, including COLLATE sequences (wherein any known upper-lower mappings reside) drop UNICODE_FSS and use UTF8 instead.

./heLen