Oracle CLOB and CFILE data types
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Oracle CLOB and CFILE data types
The Oracle CLOB and CFILE data
types are used to store blocks of unstructured data. Database columns
of these types store locators. CLOB and CFILE data
that is copied to the OpenEdge client are translated from the codepage
defined to the schema image to the -cpinternal code page just like
other character data. This includes translation for CLOBs
defined in the UTF-8 Unicode character set. If data from an Oracle CLOB is
copied to a OpenEdge data type that has a code page attached to
its type definition, then the data is converted to that target's
code page.
Note: Beginning with OpenEdge Release
11.1, the DataServer for Oracle supports partial read/write capability
to
CLOB data types using STARTING AT, FOR,
and OVERLAY AT n [TRIM] operations.