VastbaseG100

基于openGauss内核开发的企业级关系型数据库。

Menu

数据类型说明

外部类型所包含的所有数据如下:

当前不支持的内部类型有XML,JSON,几何类型,数据库对象tablespace。

External Data Type Code Program Variable(1) 是否支持
VARCHAR2 1 char[n]
NUMBER 2 unsigned char[21]
8-bit signed 3 signed char
16-bit signed 3 signed short, signed int
32-bit signed 3 signed int, signed long
64-bit signed 3 signed long, signed long long
FLOAT 4 float, double
NULL-terminated STRING 5 char[n+1]
VARNUM 6 char[22]
LONG 8 char[n]
VARCHAR 9 char[n+sizeof(short integer)]
DATE 12 char[7]
VARRAW 15 unsigned char[n+sizeof(short integer)]
native float 21 float
native double 22 double
RAW 23 unsigned char[n]
LONG RAW 24 unsigned char[n]
UNSIGNED INT 68 unsigned
LONG VARCHAR 94 char[n+sizeof(integer)]
LONG VARRAW 95 unsigned char[n+sizeof(integer)]
CHAR 96 char[n]
CHARZ 97 char[n+1]
ROWID 104 OCIRowid *
NAMED DATATYPE 108 struct
REF 110 OCIRef
Character LOB descriptor 112 OCILobLocator
Binary LOB descriptor 113 OCILobLocator
Binary FILE descriptor 114 OCILobLocator
JSON descriptor 119 OCIJson
OCI STRING 155 OCIString
OCI DATE 156 OCIDate *
ANSI DATE 184 OCIDateTime *
TIMESTAMP 187 OCIDateTime *
TIMESTAMP WITH TIME ZONE 188 OCIDateTime *
INTERVAL YEAR TO MONTH 189 OCIInterval *
INTERVAL DAY TO SECOND 190 OCIInterval *
TIMESTAMP WITH LOCAL TIME ZONE 232 OCIDateTime *