Subject Re: [ib-support] arithmetic exception, numeric overflow, or string truncation
Author Dimitry Sibiryakov
On 15 Feb 2002 at 9:57, Helen Borrie wrote:

This is the most mysterious error message. I think
somebody years ago was too lazy or too hurried to give an
exact explanation of every different error and put a lot of
cases into one.
But i saw even more strange messages. One MS' well-known
program likes to say simple "Error happend". Or just to
show an empty error message box.

> > or string truncation"
> string being inserted is longer than the declared length

Or it has a different charset. F(I)B cannot convert
strings between charsets.

> >but i'm just doing a simple insert..!?!
> A simple insert can overflow. What are you using as a client?
> Can you inspect your input?

Once upon time i got such messages every time when i
tried to insert any information into my table. At last i
found that i set the default value for a field larger
than the field itself. But i received the error even if i
supplied a "good" value for this field.

SY, Dimitry Sibiryakov.