[firebird-support] String right truncation Error

[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