# 向量化引擎支持的数据类型 向量化引擎支持的数据类型如[表1]所示。 表1向量化引擎支持的数据类型 | 类别 | 数据类型 | 长度 | |:---|:---|:---| | Numeric Types | tinyint \[unsigned\] | 1 | | Numeric Types | smallint \[unsigned\] | 2 | | Numeric Types | mediumint \[unsigned\] | 3 | | Numeric Types | integer \[unsigned\] | 4 | | Numeric Types | bigint \[unsigned\] | 8 | | Numeric Types | int16 \[signed\] | 16 | | Numeric Types | decimal | -1 | | Numeric Types | numeric | -1 | | Numeric Types | real | 4 | | Numeric Types | double precision | 8 | | Numeric Types | smallserial | 2 | | Numeric Types | serial | 4 | | Numeric Types | bigserial | 8 | | Numeric Types | largeserial | -1 | | Monetary Types | money | 8 | | Boolean Types | boolean | 1 | | Character Types | character varying(n), varchar(n) | -1 | | Character Types | character(n), char(n),nchar(n) | n | | Character Types | character、char | 1 | | Character Types | text | -1 | | Character Types | varchar2(n) | -1 | | Character Types | nvarchar2(n) | -1 | | Character Types | clob | -1 | | Binary Types | blob | -1 | | Binary Types | raw | -1 | | Binary Types | bytea | -1 | | Binary Types | byteawithoutorderwithequalcol | -1 | | Binary Types | byteawithoutordercol | -1 | | Bit String Types | bit(n) | n | | Bit String Types | bit varying(n) | -1 | | Date/Time Types | timestamp with time zone | 8 | | Date/Time Types | timestamp without time zone | 8 | | Date/Time Types | date | 4 | | Date/Time Types | time without time zone | 8 | | Date/Time Types | time with time zone | 12 | | Date/Time Types | smalldatetime | 8 | | Date/Time Types | interval | 16 | | Date/Time Types | reltime | 4 | | Date/Time Types | abstime | 4 | | Date/Time Types | datea | 8 | | Network Address Types | cidr | 7 or 19 | | Network Address Types | inet | 7 or 19 | | Text Retrieval Types | tsvector | -1 | | Text Retrieval Types | tsquery | -1 | | JSON Types | json | -1 | | JSON Types | jsonb | -1 | | HyperLoglog Types | hll | -1 | | Range Types | int4range | -1 | | Range Types | int8range | -1 | | Range Types | numrange | -1 | | Range Types | tsrange | -1 | | Range Types | tstzrange | -1 | | Range Types | daterange | -1 | | Object Identifier Types | OID | 4 | | Object Identifier Types | CID | 4 | | Object Identifier Types | XID | 8 | | Object Identifier Types | TID | 8 | | Object Identifier Types | regconfig | 4 | | Object Identifier Types | regdictionary | 4 | | Object Identifier Types | regoper | 4 | | Object Identifier Types | regoperator | 4 | | Object Identifier Types | regproc | 4 | | Object Identifier Types | regprocedure | 4 | | Object Identifier Types | regclass | 4 | | Object Identifier Types | regtype | 4 | | Pseudo Types | anyelement | 4 | | Pseudo Types | anynonarray | 4 | | Pseudo Types | anyrange | -1 | | Pseudo Types | cstring | -2 | | Pseudo Types | record | -1 | | Pseudo Types | void | 4 | | XML Types | xml | -1 | | XMLTYPE Types | xmltype | -1 | | Hash Types | hash16 | 8 | | Array Types | tinyint\[\] | -1 | | Array Types | smallint\[\] | -1 | | Array Types | mediumint\[\] | -1 | | Array Types | integer\[\] | -1 | | Array Types | bigint\[\] | -1 | | Array Types | int16\[\] | -1 | | Array Types | decimal\[\] | -1 | | Array Types | numeric\[\] | -1 | | Array Types | real\[\] | -1 | | Array Types | double precision\[\] | -1 | | Array Types | money\[\] | -1 | | Array Types | boolean\[\] | -1 | | Array Types | varchar\[\] | -1 | | Array Types | char(n)\[\] | -1 | | Array Types | char\[\] | -1 | | Array Types | text\[\] | -1 | | Array Types | varchar2(n)\[\] | -1 | | Array Types | nvarchar2(n)\[\] | -1 | | Array Types | clob\[\] | -1 | | Array Types | blob\[\] | -1 | | Array Types | raw\[\] | -1 | | Array Types | bytea\[\] | -1 | | Array Types | byteawithoutorderwithequalcol\[\] | -1 | | Array Types | byteawithoutordercol\[\] | -1 | | Array Types | bit(n)\[\] | -1 | | Array Types | bit varying(n)\[\] | -1 | | Array Types | timestamp with time zone\[\] | -1 | | Array Types | timestamp without time zone\[\] | -1 | | Array Types | date\[\] | -1 | | Array Types | time without time zone\[\] | -1 | | Array Types | time with time zone\[\] | -1 | | Array Types | smalldatetime\[\] | -1 | | Array Types | interval\[\] | -1 | | Array Types | reltime\[\] | -1 | | Array Types | abstime\[\] | -1 | | Array Types | datea\[\] | -1 | | Array Types | cidr\[\] | -1 | | Array Types | inet\[\] | -1 | | Array Types | tsvector\[\] | -1 | | Array Types | tsquery\[\] | -1 | | Array Types | json\[\] | -1 | | Array Types | jsonb\[\] | -1 | | Array Types | hll\[\] | -1 | | Array Types | int4range\[\] | -1 | | Array Types | int8range\[\] | -1 | | Array Types | numrange\[\] | -1 | | Array Types | tsrange\[\] | -1 | | Array Types | tstzrange\[\] | -1 | | Array Types | daterange\[\] | -1 | | Array Types | OID\[\] | -1 | | Array Types | CID\[\] | -1 | | Array Types | XID\[\] | -1 | | Array Types | TID\[\] | -1 | | Array Types | regconfig\[\] | -1 | | Array Types | regdictionary\[\] | -1 | | Array Types | regoper\[\] | -1 | | Array Types | regoperator\[\] | -1 | | Array Types | regproc\[\] | -1 | | Array Types | regprocedure\[\] | -1 | | Array Types | regclass\[\] | -1 | | Array Types | regtype\[\] | -1 | | Array Types | cstring\[\] | -1 | | Array Types | record\[\] | -1 | | Array Types | xml\[\] | -1 | | Array Types | xmltype\[\] | -1 | | Array Types | hash16\[\] | -1 | | Array Types | hash32\[\] | -1 | | Array Types | aclitem\[\] | -1 | | Array Types | name\[\] | -1 | | Array Types | macaddr\[\] | -1 | | Array Types | UUID\[\] | -1 | | Array Types | point\[\] | -1 | | Array Types | lseg\[\] | -1 | | Array Types | box\[\] | -1 | | Array Types | path\[\] | -1 | | Array Types | polygon\[\] | -1 | | Array Types | circle\[\] | -1 | | Vector Types | floatvector | -1 | | Vector Types | boolvector | -1 | | Other Types | enum | enum 类型由若干个标签构成的列表，每一个标签值都是一个非空字符串，且字符串长度必须不超过63个字节。 | ![](https://support.huaweicloud.com/distributed-ref-v10-gaussdb/public_sys-resources/note_3.0-zh-cn.png) enum类型当前仅支持如下方式创建，详情请参见[CREATE TYPE](https://support.huaweicloud.com/distributed-ref-v10-gaussdb/gaussdb-08-0280.html)。 ``` CREATE TYPE name AS ENUM (['label' [, ...]]); ```