RE: [firebird-support] When is varchar(10) only 7; arithmetic exception, numeric overflow, or string truncation

2012-08-28 Thread Rick Debay
, 2012 5:44 PM To: firebird-support@yahoogroups.com 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

Re: [firebird-support] When is varchar(10) only 7; arithmetic exception, numeric overflow, or string truncation

2012-08-28 Thread Ann Harrison
On Tue, Aug 28, 2012 at 10:41 AM, Rick Debay rde...@accessrxs.com wrote: I exported the original database as DDL and recreated it. It now works. Scary, as the database validation tools didn't detect any errors. The validation in gfix checks the physical structure - pointer point to the right

[firebird-support] When is varchar(10) only 7; arithmetic exception, numeric overflow, or string truncation

2012-08-27 Thread Rick Debay
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