Subject Why this returns string truncate??
Author Fabiano
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?



[Non-text portions of this message have been removed]