Subject | Re: [firebird-support] Why this returns string truncate?? |
---|---|
Author | Alexandre Benson Smith |
Post date | 2011-12-13T17:06:12Z |
Em 13/12/2011 09:32, Fabiano escreveu:
> I have this situation:Try to use charset ISO8859_1 or Win_1252
>
>
>
> 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?
>
>
>