Database Schema and Views Reference Guide › Database Schema Introduction › Datatypes

Datatypes

The database types described in this document are CA DLP datatypes. This is because CA DLP can utilize many different DBMSs and each of these has its own variation of SQL datatypes. See CA DLP Datatype Mappings for mappings between CA DLP datatypes and your own DBMS datatypes.

VARCHAR

Because each DBMS supported by CA DLP can vary the amount of physical storage needed to store VARCHAR data, the column size indicated for VARCHAR columns in this schema document refers to the number of characters, not the number of bytes. Note that for SQL Server, each character requires 2 bytes of storage, but for Oracle we recommend using the UTF-8 character set, which uses between one and three bytes to store an individual character.