Table of contents
No headers 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 |