Subject | String right truncation Error |
---|---|
Author | Aldo Caruso |
Post date | 2012-02-24T19:16:20Z |
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
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