The database types described in this document are CA Data Protection datatypes. This is because CA Data Protection can utilize many different DBMSs and each of these has its own variation of SQL datatypes. See CA Data Protection Datatype Mappings for mappings between CA Data Protection datatypes and your own DBMS datatypes.
Because each DBMS supported by CA Data Protection 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.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|