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
>
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)