| Subject | arithmetic exception, numeric overflow, or string truncation |
|---|---|
| Author | Roberto Freitas |
| Post date | 2006-11-08T23:08:57Z |
Hi, I am using FireBird 1.5 with Windows.
I submit any of these sentences using isql or other tool:
select * from doc where substr(doc3000,1,3)='ERR'
select * from doc where f_substr('ERR',doc3000)>0
doc3000 is type Varchar, size 3000, CharSet Win 1252, Collate PXW-
INTL850
substr is a external function from ib_udf
f_substr is a external function from FreeUDFLib
Unfortunatelly I get this error message:
statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
When using same sentences with a smaller field it's OK, but with a
large field like this one (varchar 3000) it fails.
What's this problem about and what can I do to solve it?
I submit any of these sentences using isql or other tool:
select * from doc where substr(doc3000,1,3)='ERR'
select * from doc where f_substr('ERR',doc3000)>0
doc3000 is type Varchar, size 3000, CharSet Win 1252, Collate PXW-
INTL850
substr is a external function from ib_udf
f_substr is a external function from FreeUDFLib
Unfortunatelly I get this error message:
statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
When using same sentences with a smaller field it's OK, but with a
large field like this one (varchar 3000) it fails.
What's this problem about and what can I do to solve it?