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 DCIRowid *
NAMED DATATYPE 108 struct
REF 110 DCIRef
Character LOB descriptor 112 DCILobLocator
Binary LOB descriptor 113 DCILobLocator
Binary FILE descriptor 114 DCILobLocator
JSON descriptor 119 DCIJson
DCI STRING 155 DCIString
DCI DATE 156 DCIDate *
ANSI DATE 184 DCIDateTime *
TIMESTAMP 187 DCIDateTime *
TIMESTAMP WITH TIME ZONE 188 DCIDateTime *
INTERVAL YEAR TO MONTH 189 DCIInterval *
INTERVAL DAY TO SECOND 190 DCIInterval *
TIMESTAMP WITH LOCAL TIME ZONE 232 DCIDateTime *