Hi all,

let me start from the beginning, as I have figured out how to reproduce (or
at least, how it happens).

( Claudio, please watch the quoting of email addresses in the messages, I
get enough spam already )


I have a database that uses char set ISO8859_1. In this character set, we
changed the default collation to DU_NL by editing the system tables. This
avoids using modifying the collation everywhere...

Second, I've created a couple of views - all work without problems.

Third, I've backed up the database and restored it -- now, when I use the
views (select ... from myview), I get the 'arithmic overflow, string
truncation' error. The weird thing is, if I take the view source and execute
it, it works just fine.

Then, I've dropped the view and re-created it with the same structure
(extract DDL, drop, run DDL). Now I can use the view like any other -- all
works fine.

I don't know if modifying the default collation has anything to do with it,
but I mention it anyway. I could not find any charset/collation info in the
system tables for views, but that just might be me...

The above issue happens with a database created with IB6 and restored on IB6
and Firebird 1, RC2.



Hope this helps,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com




[Non-text portions of this message have been removed]