Do you get the same problem when you try your insert with ISQL or
another program that uses the Firebird Client directly?

If yes, then the problem is in the database. You probably use another
character set for one or several of your columns. Did you specify
DEFAULT CHARACTER SET ISO8859_1 together with the CREATE DATABASE or
did you apply that character set later?

If no, then the problem is in the client. As I don't know anything
about ODBC on Linux I'm afraid I can't help you with that one though
...


Best Regards

Stefan

> Hi all.

> I working on SUSE linux 10.1(UTF8 charset) I'm connected via ODBC to
> my firebierd database and recieve this error when I try to insert some
> fiels en a table.

> [unixODBC][Easysoft][Firebird]arithmetic exception, numeric overflow,
> or string truncation, Cannot transliterate character between character
> sets}

> currently I use a ISO8859_1 charset on my Firebird Database and
> configure the Easysoft ODBC for ISO8859_1 charset too. What more a
> have to do?

--
Stefan Heymann
www.destructor.de/firebird