Kbase P173870: Sqldump fails with data conversion error when dumping a table with CLOB (LVARCHAR)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/09/2010 |
|
Status: Unverified
SYMPTOM(s):
Sqldump fails with data conversion error when dumping a table with CLOB (LVARCHAR)
ERROR : Data conversion error at column #6, status/rec#/intype/inlen = -20008/1/-1/31
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
Binary dump and load works without any problems
CAUSE:
SQLDUMP and SQLLOAD utilities do not support tables with LVARBINARY (BLOB) and LVARCHAR (CLOB) column data.
FIX:
Use binary dump&load to dump and load data that contains the LVARBINARY or LVARCHAR data types