表?1.1.?Oracle到UXDB数据类型转换对照
Oracle | UXDB |
---|---|
CHAR | CHAR |
NCHAR | CHAR |
VARCHAR | VARCHAR |
VARCHAR2 | VARCHAR |
NVARCHAR2 | VARCHAR |
CLOB | TEXT |
LONG | TEXT |
RAW | UUID |
BLOB | BYTEA |
LONG RAW | BYTEA |
NUMBER | NUMERIC |
FLOAT | FLOAT |
DATE | DATE |
TIMESTAMP | TIMESTAMP |
TIMESTAMP WITH TIME ZONE | TIMESTAMPTZ |
TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMPTZ |