DBD::InterBase

Hello, it's me again. ;-)

I've created a database with the following setting:
DEFAULT CHARACTER SET ISO8859_1 with Firebird 1.5 RC4 under SuSE Linux 8.2

The varchar's are created with CHARACTER SET ISO8859_1

So everything should be ready for german characters like äöüÄÖÜß.

When I accept the database from Windows, I can store any characters in it. When I use Perl with dbi-interbase, I get the following error:

Arithmetic overflow or division by zero has occurred.
-arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets

Any ideas?

Thanks in advance

Christian

OK, it's the same problem Carlos has.

Sorry for duplication

Best regards

Christian

try add ib_charset=ISO8859_1 in the conenction string.
For example: dbi:InterBase:db=/tmp/test.gdb;ib_dialect=3;ib_charset=ISO8859_1

Perfect Edwin,

it works!

Is it documented somewhere?

Christian