Subject Re: [ib-support] arithmetic exception, numeric overflow, or string truncation
Author Lucas Franzen
Dimitry Sibiryakov schrieb:
>
> On 15 Feb 2002 at 5:20, Claudio Valderrama C. wrote:
>
> > I once explained Jason Wharton why this
> > message cannot be enhanced [easily] to say which is the field that failed.
> > Basically, at the [low] level it's detected and handled, there's no info
> > about field names. At most, you find descriptors.
> >
> > (Or I would have done something about it already.)

Dimitry,

>
> Ok, server can't tell us the name of the wrong field. But
> I still wonder how it is possible - to mix up a numeric
> overflow and inability to convert a string between
> charsets.

when there's charcter set error when converting a string between
character sets then the error usually is "CANNOT TRANSLITERATE BETWEEN
CHARCTER SETS" and not "ARITHMETIC EXCEPTION ...".

And there are different codes for these errors.

Exception: SQLCode ISCError
---------------------------------------------
Arithmetic exception -802 335544321
Cannot transliterate -314 335544565

Luc.