Have a look at the langref.pdf
http://firebird.sourceforge.net/index.php?op=doc&id=userdoc document at
page 278 there is a list of supported character sets. You have to set the
character set during database creation, table (column) creation, during
selection or when connecting to a database. I think you need charset
UNICODE_FFS. Try to set it during the connection.

Am 04.07.2004 16:22 Uhr schrieb "hdwur" unter <hdwur@...>:

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

--
_ _ _
)) _ __ ___ ))_ ___ __ __))
((_)((_( (| ((_( ((`( ((_( (| ((_(
_))
http://www.news.cornell.edu/releases/July97/guitar.ltb.html



[Non-text portions of this message have been removed]