数据仓库服务 GaussDB(DWS)-二进制类型:类型对照

时间：2025-02-12 15:05:07

类型对照

表1 二进制类型对照表
MySQL二进制类型	MySQL INPUT	GaussDB (DWS) OUTPUT
BIT[(M)]	BIT[(M)]	BIT[(M)]
BINARY[(M)]	BINARY[(M)]	BYTEA
CHAR BYTE[(M)]	BINARY[(M)]	BYTEA
VARBINARY[(M)]	VARBINARY[(M)]	BYTEA

输入示例BIT

  
       CREATE TABLE IF NOT EXISTS `runoob_dataType_test`(    `dataType_1` INT,    `dataType_2` BIT(1),    `dataType_3` BIT(64));

输出示例

  
       CREATE TABLE IF NOT EXISTS "public"."runoob_datatype_test"(  "datatype_1" INTEGER,  "datatype_2" BIT(1),  "datatype_3" BIT(64))  WITH ( ORIENTATION = ROW, COMPRESSION = NO )  NOCOMPRESS  DISTRIBUTE BY HASH ("datatype_1");

输入示例[VAR]BINARY

  
       CREATE TABLE IF NOT EXISTS `runoob_dataType_test`(    `dataType_1` INT,    `dataType_2` BINARY,    `dataType_3` BINARY(0),    `dataType_4` BINARY(255),    `dataType_5` VARBINARY(0),    `dataType_6` VARBINARY(6553));

输出示例

  
       CREATE TABLE IF NOT EXISTS "public"."runoob_datatype_test"(  "datatype_1" INTEGER,  "datatype_2" BYTEA,  "datatype_3" BYTEA,  "datatype_4" BYTEA,  "datatype_5" BYTEA,  "datatype_6" BYTEA)  WITH ( ORIENTATION = ROW, COMPRESSION = NO )  NOCOMPRESS  DISTRIBUTE BY HASH ("datatype_1");