Hi people,
how do i input data (containing german chars. like "äöüß") into an
interbase 6.5 db created using character set ISO_8859_1 in a java app.?

I get this message:
........
interbase.interclient.SQLException: [interclient][interbase] arithmetic
exceptio
n, numeric overflow, or string truncation
Cannot transliterate character between character sets

I´ve tried connecting using the properties option:
Properties props = new Properties();
props.setProperty( "user", USER );
props.setProperty( "password", PASSWORD );
props.setProperty( "charSet", "_8859_1" );

oSQLConn = DriverManager.getConnection( getDBURL(), props );

But get an error message:
login failed:[interclient] Unsupported feature: Driver does not support
specified character encoding .......

Any ideas??

Cheers,
Mark