Try OpenEdge Now
skip to main content
DataServer for Oracle
Initial Programming Considerations : Data types : Oracle CLOB and CFILE data types
 

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.