""Dimitry Sibiryakov"" <SD@...> wrote in message
news:3C6D3769.1242.595E297@localhost...

>
> 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.

No. The error is the same if you have a numeric overflow or string that
doesn't fit. It's different if the charsets don't match => cannot
transliterate.

Besides that, Chris Jewell (former Borland employee that implemented dialect
3 with Dave Schnepper) chose to return in some cases a different error for
exact numeric overflow:

SQL> select 5000000000000000000*(-10) from rdb$database;


=====================
Statement failed, SQLCODE = -901

Integer overflow. The result of an integer operation caused the most
significant bit of the result to carry.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing