Devart Forums

I've been testing the latest IBDAC v7.1.3 with Firebird v2.5.9 and v.3.0.5.

I open JOB table from both of these example databases:

C:\Program Files (x86)\Firebird\Firebird_2_5\examples\empbuild\EMPLOYEE.FDB
C:\Program Files (x86)\Firebird\Firebird_3_0\examples\empbuild\EMPLOYEE.FDB

and I get the following exception:

procedure TCustomIBCArray.Check(Status: ISC_STATUS);

SqlErrMsg = 'Arithmetic overflow or division by zero has occurred.'
Msg = 'arithmetic exception, numeric overflow, or string truncation'#$D'string right truncation'
ErrorNumber = 335544321
ErrorCode = -802

Is this IBDAC issue or is that Firebird table broken in both versions? I bet the first since the data seems to be fine.

Open I mean "SELECT * FROM JOB" in TIBCQuery (DeferredArrayRead = True). It seems that the problem is LANGUAGE_REQ field (string array 1:5). If I leave that field out, the query works.

There is QUART_HEAD_CNT field (integer array 1:4) in PROJ_DEPT_BUDGET table and it works.

Hello,
Unfortunately, we haven't been able to reproduce the issue.
To give you a complete answer, we need to first look into sample code demonstrating the issue, also we need to know the exact version of your IDE. Please send us the code sample through the form on our website: https://www.devart.com/company/contactform.html

wbr, Oleg
DAC Team

I will send a simple example project for you. I am using the latest version Delphi 10.3.3.

Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.
Note that the issue only occurs when you use the UTF-8 charset.

wbr, Oleg
DAC Team