On 24-2-2012 20:16, Aldo Caruso wrote:

> 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.

Not sure what would cause this, but what happens if you do:
* Select only CODIGO from the view
* Select only NOMBRE from the view
* Drop and recreate the view

Have you checked the view definition if it might contain smaller column
than the source table?

Mark
--
Mark Rotteveel