This section shows the mappings from FDO data types to ArcSDE data types to Oracle data types:
FDO DataType | sdetable Column Definition | Oracle Column Type |
---|---|---|
FdoDataType_Boolean |
Not supported |
Not supported |
FdoDataType_Byte |
Not supported |
Not supported |
FdoDataType_DateTime |
date |
DATE |
FdoDataType_Decimal |
Not supported |
Not supported |
FdoDataType_Double |
double(38,8) |
NUMBER(38,8) |
FdoDataType_Int16 |
integer(4) |
NUMBER(4) |
FdoDataType_Int32 |
integer(10) |
NUMBER(10) |
FdoDataType_Int64 |
Not supported |
Not supported |
FdoDataType_Single |
float(6,2) // typical float(0<n<=6, o<m<DBMSLimit)) // possible |
NUMBER(6,2) NUMBER(n,8) |
FdoDataType_String |
string(<length>) |
VARCHAR2(<length>) |
FdoDataType_BLOB |
blob |
LONG RAW |
FdoDataType_CLOB |
Not supported |
Not supported |
FdoDatatype_UniqueID |
Not supported |
Not supported |