2023年7月13日发(作者：)

ArcGIS 字段类型对照

esriFieldType

(IField::Type)

VB Variable Type

(IField::VarType)

Number (Integer)

Number (Long Integer)

Number (Single)

Number (Double)

Text

Date/Time

smallint

int

float

float

varchar

datetime

NUMBER

NUMBER

NUMBER

NUMBER

VARCHAR2

DATE

NUMBER(38)

NUMBER(38) or SDO_GEOMETRY

NUMBER(38) or SDO_GEOMETRY

NUMBER

Access SQL Server Oracle

ArcCatalog

Short Integer esriFieldTypeSmallInteger vbInteger

Long Integer

Float

Double

Text

Date

Object ID

Geometry

Blob

Raster

GUID

GlobalID

esriFieldTypeInteger

esriFieldTypeSingle

esriFieldTypeDouble

esriFieldTypeString

esriFieldTypeDate

esriFieldTypeOID

esriFieldTypeGeometry

esriFieldTypeBlob

esriFieldTypeRaster

esriFieldTypeGUID

esriFieldTypeGlobalID

vbLong

vbSingle

vbDouble

vbString

vbDate

vbLong

vbDataObject

vbObject

vbDataObject

vbString

vbString

AutoNumber (Long Integer) int

OLE Object

OLE Object

Number (Long Integer)

Number (Replication ID)

Number (Replication ID)

int

image

int

uniqueidentifier CHAR

uniqueidentifier CHAR