Subject Re: [firebird-support] Why this returns string truncate??
Author Alexandre Benson Smith
Em 13/12/2011 09:32, Fabiano escreveu:
> I have this situation:
>
>
>
> CREATE TABLE TESTE (TXT VARCHAR(100));
>
>
>
> insert into TESTE(TXT) values ('MECƒNICA');
>
>
>
> This simple select return “Arithmetic overflow or division by zero has
> occurred. Arithmetic exception, numeric overflow, or string truncation.
> String right truncation.”
>
>
>
> select UPPER(TXT) from TESTE
>
>
>
> Tested with FB 2.5.1 and 2.5.0.
>
> Why it occurs?
>
>
>


Try to use charset ISO8859_1 or Win_1252