Kbase P92737: Error 223 assigning SQL92 CHARACTER fields from 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Getting error 223 trying to assign the CHARACTER fields from 4GL
** Incompatible data types in expression or assignment. (223)
Table was created via SQL92 engine with CREATE TABLE command.
Table contains CHARACTER fields
Getting error 223 trying to assign the CHARACTER fields from 4GL
** Incompatible data types in expression or assignment. (223)
CAUSE:
This is expected behavior.
FIX:
SQL92 CHARACTER (alis CHAR) corresponds to a null-terminated character string with the length specified. Values are padded with blanks to the specified length.
The default length is 1. The maximum length is 2000 characters.
SQL92 CHARACTER VARYING | CHAR VARYING | VARCHAR corresponds to variable-length character string with the maximum length specified. The default length is 1. The maximum length is 31995 characters.
4GL character data type is mapped to SQL92 VARCHAR data type.