Re: [ib-support] arithmetic exception, numeric overflow, or string truncation
Author
Dimitry Sibiryakov
Post date
2002-02-15T05:38:20Z
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.