Kbase P53256: What are SQL equivalents for CLOB and BLOB data types in OpenEdge 10?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/01/2011 |
|
Status: Verified
GOAL:
What are SQL equivalents for CLOB and BLOB data types in OpenEdge 10?
GOAL:
Is there a BLOB data type in OpenEdge SQL?
GOAL:
Is there a CLOB data type in OpenEdge SQL?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
OpenEdge SQL provides CLOB and BLOB data types in OpenEdge 10.1A and above.
In OpenEdge 10.0x the data types are mapped as follows:
CLOB (4GL) --> LVARCHAR (SQL-92)
BLOB (4GL) --> LVARBIN (SQL-92)