Subject | Why this returns string truncate?? |
---|---|
Author | Fabiano |
Post date | 2011-12-13T11:32:27Z |
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]
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]