Try Charset=NONE if you use IB6. It worked for me.

----- Original Message -----
From: "Riho-Rene Ellermaa" <riho.ellermaa@...>
To: <IBDI@yahoogroups.com>
Sent: Monday, February 26, 2001 9:07 AM
Subject: [IBDI] Charset problem


> Hi!
>
> somehow one of my customers managed to get accented characters into a
field
> where they shouldn't be (at least I think that).
> In field VARCHAR(20) I get error
>
> ISC ERROR CODE:335544321
>
> ISC ERROR MESSAGE:
> arithmetic exception, numeric overflow, or string truncation
> Cannot transliterate character between character sets
>
> How can I see what this field actually contains? I tried to convert the
> field to datatype
> VARCHAR(20) Character Set WIN1252 (that's what I use elsewere)
> but it didn't help.
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
> >
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>