Kbase P128590: Unwanted trailing space is being added when running an OE SQL CAST
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
SYMPTOM(s):
Unwanted trailing space is being added when running an OE SQL CAST
The target has to be +1 larger to cast correctly
Running select cast(cast (10.5 as decimal(3,1)) as char(4)) from table
CAUSE:
This is a known issue
FIX:
Run the following SQL statement adding one more character to the target:
select distinct cast(cast ( 10.5 as decimal(3,1)) as char(5)) from table