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
nexusalpha.jaf2.services.communications.server.database_abstraction.ad
dress.AddressDatabase.loadVisibleTemplateAddresses
(AddressDatabase.java:251)
at
nexusalpha.jaf2.services.communications.server.TemplateAddressListMana
ger.initilize(AddressBookServer.java:316)
at
nexusalpha.jaf2.services.communications.server.AddressBookServer.<init

>(AddressBookServer.java:73)

at
nexusalpha.jaf2.services.communications.server.ServiceManager.initiliz
eService(ServiceManager.java:134)
at
nexusalpha.jaf2.services.communications.server.ServiceManager.initiliz
e(ServiceManager.java:84)
at nexusalpha.jaf2.service_manager.ServiceManager.startStopService
(ServiceManager.java:269)
at
nexusalpha.jaf2.service_manager.ServiceManager.startStopServicesAtInit
ilizeLevel(ServiceManager.java:224)
at nexusalpha.jaf2.service_manager.ServiceManager.startStopServices
(ServiceManager.java:191)
at nexusalpha.jaf2.service_manager.ServiceManager.initilize
(ServiceManager.java:84)
at nexusalpha.jaf2.service_manager.ServiceManager.startServices
(ServiceManager.java:34)
at nexusalpha.jaf2.application.stand_alone.StandAloneApplication$1.run
(StandAloneApplication.java:118)
at java.lang.Thread.run(Thread.java:536)