Kbase P114611: The OpenEdge SQL-92 does not support the LONG VARCHAR data type
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
The OpenEdge SQL-92 does not support the LONG VARCHAR data type
A CREATE TABLE statement produces a syntax error when specifying LONG VARCHAR as the column data type
CAUSE:
OpenEdge uses a different syntax for the LONG VARCHAR data type.
FIX:
Define the column as a CLOB or LVARCHAR data type instead of LONG VARCHAR.