Subject | problem with blob field |
---|---|
Author | Rodrigo Albanaz |
Post date | 2002-06-19T18:24:41Z |
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?
[Non-text portions of this message have been removed]
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?
[Non-text portions of this message have been removed]