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