FDO Provider for ArcSDE Connection
OSGeo FDO Provider for ArcSDE
Creating a Feature Schema
Data Type Mappings
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
|