第?6?章?附录

表?6.1.?Oracle到UXDB数据类型映射

Oracle类型UXDB类型
NUMBERnumeric
CHARchar
NCHARchar
VARCHAR2varchar
NVARCHAR2varchar
FLOATfloat8
DATETimestamptz(0)
TIMESTAMPtimestamp
TIMESTAMP WITH TIME ZONEtimestamptz
TIMESTAMP WITH LOCAL TIME ZONEtimestamptz
INTERVAL YEAR TO MONTHinterval
INTERVAL DAY TO SECONDinterval
RAWbytea
BINARY_FLOATfloat4
BINARY_DOUBLEfloat8
BFILEbytea
BLOBbytea
CLOBtext
LONGtext
LONG RAWbytea
ROWID/UROWID不支持

表?6.2.?Mysql到UXDB数据类型映射

Mysql类型UXDB类型
Intint8
tinyintint2
smallintint2
mediumintint4
bigintint8
decimalnumeric
floatfloat8
doublefloat8
charchar
varcharvarchar
tinytexttext
texttext
mediumtexttext
longtexttext
datedate
timetime
datetimetimestamp
timestamptimestamp
longblobbytea
jsonjson
yearnumeric
tinyblobbytea
mediumblobbytea
binarybytea
bitbit

表?6.3.?Sql Server到UXDB数据类型映射

Sql Server类型UXDB类型
int IDENTITY(1,1)SERIAL
texttext
ntexttext
smallintSMALLINT
nvarcharVARCHAR
imageBYTEA
ncharCHAR
intint
smallintsmallint
moneynumeric(19,4)
realfloat(24)
bitboolean
datetimeTIMESTAMP
smalldatetimeTIMESTAMP
timestampbytea
bigintbigint
tinyintsmallint
SMALLMONEYmoney
DOUBLE PRECISIONfloat
TINYINTsmallint
nvarchar(max)text

表?6.4.?Sybase到UXDB数据类型映射

Sybase类型UXDB类型
INTINT4
BITBIT
TINYINTINT2
SMALLINTINT2
UNSIGNED SMALLINTINT4
UNSIGNED INTINT8
BIGINTINT8
UNSIGNED BIGINTINT8
DECIMALNUMERIC
NUMERICNUMERIC
FLOATFLOAT8
FLOATFLOAT8
REALFLOAT4
SMALLMONEYNUMERIC
MONEYNUMERIC
DATEDATE
TIMETIMESTAMP
BIGTIMETIMESTAMP
SMALLDATETIMETIMESTAMP
DATETIMETIMESTAMP
BIGDATETIMETIMESTAMP
CHARCHAR
NCHARCHAR
UNICHARCHAR
VARCHARVARCHAR
NVARCHARVARCHAR
UNIVARCHARVARCHAR
TEXTTEXT
UNITEXTTEXT
SYSNAMEVARCHAR
LONGSYSNAMEVARCHAR
BINARYBYTEA
VARBINARYBYTEA
IMAGEBYTEA
TIMESTAMPTIMESTAMP

表?6.5.?Db2到UXDB数据类型映射

Db2类型UXDB类型
INTINT4
BITBIT
TINYINTINT2
SMALLINTINT2
UNSIGNED SMALLINTINT4
UNSIGNED INTINT8
BIGINTINT8
UNSIGNED BIGINTINT8
DECIMALNUMERIC
NUMERICNUMERIC
FLOATFLOAT8
REALFLOAT4
SMALLMONEYNUMERIC
MONEYNUMERIC
DATEDATE
TIMETIMESTAMP
BIGTIMETIMESTAMP
SMALLDATETIMETIMESTAMP
DATETIMETIMESTAMP
BIGDATETIMETIMESTAMP
CHARCHAR
NCHARCHAR
UNICHARCHAR
VARCHARVARCHAR
NVARCHARVARCHAR
UNIVARCHARVARCHAR
TEXTTEXT
UNITEXTTEXT
SYSNAMEVARCHAR
LONGSYSNAMEVARCHAR
BINARYBYTEA
VARBINARYBYTEA
IMAGEBYTEA
TIMESTAMPBYTEA

XML 地图 | Sitemap 地图