I exported the original database as DDL and recreated it. It now works. Scary, as the database validation tools didn't detect any errors.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Rick Debay Sent: Monday, August 27, 2012 5:44 PM To: [email protected] Subject: [firebird-support] When is varchar(10) only 7; arithmetic exception, numeric overflow, or string truncation I have a stored procedure that reads from an external file table. One of the fields is varchar(10) in the stored procedure and char(10) in the file. I am selecting from the stored procedure and inserting in to a table which has a matching varchar(10) COLLATE ISO8859_1 field. If a field is empty (LTRIM(column)='') the stored procedure returns NULL for the field. I get the error 'arithmetic exception, numeric overflow, or string truncation' if this varchar(10) field is not empty and it is inserted in to the other table. I am completely baffled as the table and stored procedure are defined as varchar(10). There are other fields defined as varchar and they work fine. If I use STRLEN it says the source field is ten characters. If I copy the field from the file and put it explicitly in the insert ('62500445 ' ) it fails. If I trim it so that it's only seven characters it works. The version of Firebird is "WI-V6.3.6.5026 Firebird 1.5" ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links
