On Mon, 20 Feb 2012 14:18:25 +0100, "Olaf Kluge" <[email protected]> wrote: > Hallo, > > > > we have some problems by inserting data into an table. In our case, the > customer inserts characters in a field varchar(XX) with special character > “°”. This little ° with character set iso8859_1 and collation de_de by > inserting generates a gds-exception error: 335544321 arithmetic exception, > numeric overflow, or string truncation. Cannot transliterate character > between character sets.
What is your connection characterset? Are you sure the character in question is ISO-8859-1 0xBA (U+00BA; MASCULINE ORDINAL INDICATOR in unicode)? Mark
