|
|
|
This appendix defines the SQL type mappings used by CA DLP to map CA DLP SQL Types to a DBMS specific datatype.
|
CA DLP Type |
MS SQL Type |
Oracle Type |
|
IDENTITYDEF |
Decimal(28,0)identity(1,1) |
NUMERIC |
|
IDENTITYREF |
Decimal(28,0)identity(1,1) |
NUMERIC |
|
INTEGER |
INT |
NUMBER(10) |
|
VARCHAR |
VARCHAR |
VARCHAR2 |
|
DECIMAL |
DECIMAL |
NUMBER |
|
TIMESTAMP |
DATETIME |
DATE |
|
BIT |
BIT |
NUMBER(1,0) |
|
VARBINARY |
VARBINARY |
RAW |
|
LONGVARCHAR |
TEXT |
VARCHAR2(4000) |
|
LONGVARBINARY |
IMAGE |
LONG RAW |
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |