Subject Charset problem
Author Riho-Rene Ellermaa
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
>