Hi,
I am a new user of Firebird database. I am learning to use this
database server. In my application, I need to store traditional
Chinese characters to the varchar columns of several tables. When I
inserted a string composing of Chinese characters and general
character to the varchar column, the following exception occured:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321.
arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

at
org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate
(AbstractPreparedStatement.java:144)
at TestDriver.test0(TestDriver.java:32)
at TestDriver.main(TestDriver.java:56)
at org.firebirdsql.gds.GDSException: arithmetic exception, numeric
overflow, or string truncation
Cannot transliterate character between character sets
at org.firebirdsql.jca.FBManagedConnection.executeStatement
(FBManagedConnection.java:776)
at org.firebirdsql.jdbc.AbstractConnection.executeStatement
(AbstractConnection.java:913)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute
(AbstractPreparedStatement.java:441)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate
(AbstractPreparedStatement.java:147)
at TestDriver.test0(TestDriver.java:32)
at TestDriver.main(TestDriver.java:56)

For my case, could anyone tell me should I specify the character
set when I create the database and the tables? Should I specify
encoding in the url connect string too?

Your help will be highly appreciated!
Regards,
Michael Wu