Subject String right truncation Error
Author Aldo Caruso
Hi,

I migrated from Firebird 2.0 to 2.5
The databas has a VIEW wich basically selects two fields: CODIGO (
Integer ) and NOMBRE (Varchar 50 ) from a table.
When in Firebird 2.0 there was no problem running SELECT * FROM
<VIEW_NAME>
Now, in Firebird 2.5 I got the following error message:

SQL> select * from <VIEW NAME>l;

CODIGO NOMBRE
======= ==============================
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation


I suspect this has something to do with character sets. In the
underlying table, the field NOMBRE is VARCHAR(50) ISO8859_1
Thanks in advance for any help.

Aldo