Walter,

Walter Ogston schrieb:

> My database was created thus:
> DEFAULT CHARACTER SET ISO8859_1;

> The table was created thus:
> CREATE TABLE PARTITION_ELEMENTS(
> DOMAIN_NUMBER INTEGER NOT NULL,
> PARTITION_NUMBER INTEGER NOT NULL,
> ELEMENT_NUMBER INTEGER NOT NULL,
> DESCRIPTION VARCHAR(64) NOT NULL
> );


> I get the following error:
>
> ISC ERROR CODE:335544321
>
> ISC ERROR MESSAGE:
> arithmetic exception, numeric overflow, or string truncation
> Cannot transliterate character between character sets

Set the character set of your Firebird-Connection-Component (whatever
you use) to ISO8859_1, too.

Defining the database character set doesn't tell the client side which
one to use.


Luc.