Kbase P114478: CLOB field is not empty after being set to the empty string
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
CLOB field is not empty
CLOB field previously set to empty string using a variable
Variable has type LONGCHAR
Variable being concatenated with the empty string
CLOB field contains 4 null bytes after assignment
CLOB field contains 1000 null bytes after assignment
CAUSE:
Bug# 20060320-008
FIX:
Upgrade to 10.1A01, 10.1B or later.
Workaround: check that the variable does not contain the empty string before doing the COPY-LOB operation:
IF LENGTH(myVar)>0 THEN COPY-LOB ...