Subject Re: Problem in UPPER() function at conversion from FB1.5.4 to FB2.1
Author Dorin Pacurar
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) )
>
> Tom
>
> > I've just converted FB1.5.4 to FB 2.1.
> >
> > It seems to be a problem in UPPER function.
> >
> > When I tried to select SELECT UPPER(DENUMIRE) … from a table I've got
> > "Arithmetic exception, numeric overflow, or string truncation. Cannot
> > transliterate character between character sets"
>