> Hi,
> I have a table where a field is BLOB type, and the field's DDL is :
>
> NameField BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET ISO8859_1
>
> and the problem is that the field doesn't accept more than 256 chars.
> I use an UDF function that converts from String to BLOB, but I think that
> this is not the problem.
>
> The error description is "arithmetic exception, numeric overflow,
> or string truncation. Cannot transliterate character between
> character sets"
>
> Anybody knows how to fix this problem?

How was the UDF declared in your database and how do you use it?

Do you specify the character set ISO8859_1 at connect time? Are
there any special characters within the string field on which
the UDF is used?



Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com