Kbase P60031: Length of Logical in UTF-8 returns 3 instead of 1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/04/2008 |
|
Status: Verified
SYMPTOM(s):
STRING of Logical value returns "Y " in UTF-8
LENGTH of string returns 3 rather than 1
Database has been converted to UTF-8
Using -CPINTERNAL UTF-8 and -CPSTREAM UTF-8
If FORMAT is not used, correct value is returned
If no -CPINTERNAL is specified then the correct result is returned
Same behavior in GUI, batch-mode and WebSpeed
CAUSE:
Bug# 20031218-011
FIX:
Option #1
Upgrade to OpenEdge 10.0B03 or later
Option #2
Use the TRIM function to remove trailing spaces