First I'd like to say many thanks for the driver and for the response
to my post.

I've tried setting the 'lc_ctype' property to 'ISO_8859_1' and it has
no effect. I still get the same exception in the same place. The code
Im using to obtain the connection is as follows :

final Properties info = new Properties();
info.setProperty( "user", ...);
info.setProperty( "password", ...);
info.setProperty( "lc_ctype", "ISO_8859_1" );

return DriverManager.getConnection
("jdbc:firebirdsql:localhost/3050:C:\\AName.gdb", info));

Now I have a query which does a SELECT DISTINCT( 5 ) FROM FOO and
this one runs ok. But when a query selects all the fields, the
exception is thrown. Note: not all the VARCHAR fields that are being
have 'CHARACTER SET ISO8859_1 COLLATE EN_UK' applied. I dont know if
this a problem ?

Thanks

Ryan Baldwin

--- In Firebird-Java@y..., "rrokytskyy" <rrokytskyy@y...> wrote:
> What is the value of the "lc_ctype" property specified on
connection?
> Try setting it to "ISO_8859_1".
>
> Best regards,
> Roman Rokytskyy
>
> --- In Firebird-Java@y..., "ryanb486" <ryan.baldwin@n...> wrote:
> >
> > When excecuting a query against a table of the following form, I
> get
> > the exception at the end of this post.
> >
> > CREATE TABLE FOO (
> > 1 INTEGER,
> > 2 CHAR(1),
> > 3 VARCHAR( 64) CHARACTER SET ISO8859_1 COLLATE EN_UK,
> > 4 VARCHAR(128) CHARACTER SET ISO8859_1 COLLATE EN_UK,
> > 5 VARCHAR( 64) CHARACTER SET ISO8859_1 COLLATE EN_UK,
> > 6 CHAR(1),
> > 7 VARCHAR(512),
> > 8 INTEGER,
> > 9 INTEGER,
> > 10 VARCHAR( 256 ),
> > 11 VARCHAR( 32 ),
> > 12 INTEGER,
> > 13 INTEGER,
> > 14 INTEGER,
> > 15 INTEGER );
> >
> >
> >
> > java.sql.SQLException: fetch problem:
> > org.firebirdsql.gds.GDSException: arithmetic exception, numeric
> > overflow, or string truncation Cannot transliterate character
> between
> > character sets
> >
> > at org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.next
> > (FBResultSet.java:2535)
> > at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:157)
>
> > at
> >