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