Kbase P17406: Data returned via a SQL89 query appears truncated
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/7/2009 |
|
Status: Verified
SYMPTOM(s):
Performing a SQL Query.
Data returned is truncated.
The data contained within the field is longer than what is being displayed.
FACT(s) (Environment):
Progress 8.x
Progress 9.x
MERANT 3.50 32-BIT Progress SQL-89
MERANT 3.60 32-BIT Progress SQL-89
MERANT 3.70 32-BIT Progress SQL-89
MERANT 4.0 32-BIT Progress SQL-89
All Supported Operating Systems
CAUSE:
The "format" property value for a field(s) is less than the number of characters contained within the field. The "format" property is a display property that states the number of characters to display to the screen. The "format" field is only the display size and does not regulate the size of data that can be contained. All fields within the Progress RDBMS are variable length.
SQL specifications require a fixed length.
For example, if a name field (char) has a format of x(8), only the first eight characters of the name will be displayed.
FIX:
Via Data Dictionary adjust the display format value of the field to be displayed to the desired value.
ie: Field-Name Properties:
Current: Format x(40)
Desired: Format x(60)