默认数据类型映射

MySQL与虚谷数据库的默认数据类型映射如表1所示。

MySQL数据类型	MySQL列类型	Xugu数据类型	Xugu列类型
BIT(1)	BIT	BOOLEAN	BOOLEAN
BIT(>1)	BIT	BINARY	BINARY
TINYINT(1) SIGNED, BOOLEAN	BIT/BOOLEAN/TINYINT	TINYINT	TINYINT
TINYINT( > 1) SIGNED	TINYINT	TINYINT	TINYINT
TINYINT( any ) UNSIGNED	TINYINT UNSIGNED	SMALLINT	SMALLINT
SMALLINT[(M)] [UNSIGNED]	SMALLINT [UNSIGNED]	SMALLINT	SMALLINT
MEDIUMINT[(M)] [UNSIGNED]	MEDIUMINT [UNSIGNED]	NUMERIC	NUMERIC
INT,INTEGER[(M)]	INTEGER	INTEGER	INTEGER
INT,INTEGER[(M)] UNSIGNED	INTEGER UNSIGNED	BIGINT	BIGINT
BIGINT[(M)]	BIGINT	BIGINT	BIGINT
BIGINT[(M)] UNSIGNED	BIGINT UNSIGNED	BIGINT	BIGINT
FLOAT[(M,D)]	FLOAT	FLOAT	FLOAT
DOUBLE[(M,B)] [UNSIGNED]	DOUBLE	DOUBLE	DOUBLE
DECIMAL[(M[,D])] [UNSIGNED]	DECIMAL	NUMERIC	NUMERIC
DATE	DATE	DATE	DATE
DATETIME	DATETIME	DATETIME	DATETIME
TIMESTAMP[(M)]	TIMESTAMP	TIMESTAMP	TIMESTAMP
TIME	TIME	TIME	TIME
YEAR[(2|4)]	YEAR	SMALLINT	SMALLINT
CHAR(M)	CHAR	CHAR(M)	CHAR
VARCHAR(M)	VARCHAR	VARCHAR	VARCHAR
BINARY(M), CHAR(M) BINARY	BINARY	BINARY	BINARY
VARBINARY(M), VARCHAR(M) BINARY	VARBINARY	BINARY	BINARY
BLOB	BLOB	BLOB	BLOB
TINYBLOB	TINYBLOB	BLOB	BLOB
MEDIUMBLOB	MEDIUMBLOB	BLOB	BLOB
LONGBLOB	LONGBLOB	BLOB	BLOB
TEXT	TEXT	CLOB	CLOB
TINYTEXT	TINYTEXT	CLOB	CLOB
MEDIUMTEXT	MEDIUMTEXT	CLOB	CLOB
LONGTEXT	LONGTEXT	CLOB	CLOB
JSON	JSON
GEOMETRY	GEOMETRY
ENUM('value1','value2',...)	CHAR
SET('value1','value2',...)	CHAR

说明：

• 对于MySQL数据库中整型数据带精度的场景，兼容规则按照去掉精度的方式进行替换，不影响迁移数据及使用。如：int(10) 替换成int，去掉精度。
• 虚谷数据库的int类型，不需要且不能设置精度。