{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Mysql","Oracle","达梦","金仓","神通","Sqlite","GBase","OpenGauss","Postgresql","DB2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mysql","index":0,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,6,0],[36,0,44,0],[52,0,53,6],[7,0,8,0],[9,0,10,0],[26,0,35,0],[11,0,14,0],[45,0,49,0],[15,0,25,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","TINYINT(长度)",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<3)||(columnPrecision>0&&columnPrecision<3))\nINT1\nBOOL\nBOOLEAN","1 Bytes 范围（有符号）(-128，127) 范围（无符号）(0，255) 小整数值"]
[null,"SMALLINT(长度)",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<6)||(columnPrecision>0&&columnPrecision<6))\nINT2","2 Bytes 范围（有符号）(-32 768，32 767) 范围（无符号）(0，65 535)  大整数值"]
[null,"MEDIUMINT(长度)",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<9)||(columnPrecision>0&&columnPrecision<9))","3 Bytes 范围（有符号）(-8 388 608，8 388 607) 范围（无符号）(0，16 777 215)  大整数值"]
[null,"INT(长度)",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<11)||(columnPrecision>0&&columnPrecision<11))\nINT4","4 Bytes 范围（有符号）(-2 147 483 648，2 147 483 647) 范围（无符号）(0，4 294 967 295)  大整数值"]
[null,"INTEGER(长度)",{"$nulls":4},"同上"]
[null,"BIGINT(长度)",null,null,null,"NUMBER&&columnScale==0\nINT8","8 Bytes 范围（有符号）(-9,223,372,036,854,775,808，9 223 372 036 854 775 807) 范围（无符号）(0，18 446 744 073 709 551 615)  极大整数值"]
["浮点数据类型","FLOAT",null,null,null,"FLOAT4","4 Bytes 范围（有符号）(-3.402 823 466 E+38，-1.175 494 351 E-38)，0，(1.175 494 351 E-38，3.402 823 466 351 E+38) 范围（无符号）0，(1.175 494 351 E-38，3.402 823 466 E+38)  单精度 浮点数值"]
[null,"DOUBLE",null,null,null,"FLOAT8\nDOUBLE PRECISION","8 Bytes 范围（有符号）(-1.797 693 134 862 315 7 E+308，-2.225 073 858 507 201 4 E-308)，0，(2.225 073 858 507 201 4 E-308，1.797 693 134 862 315 7 E+308)范围（无符号）0，(2.225 073 858 507 201 4 E-308，1.797 693 134 862 315 7 E+308)  双精度 浮点数值"]
["定点数据类型","DECIMAL(精度,标度)",null,null,null,"NUMBER\nREAL\nNUMERIC","对DECIMAL(M,D) ，如果M>D，为M+2 否则为D+2 小数值"]
[null,"DEC(精度,标度)",{"$nulls":4},"同上"]
["位数据类型","BIT(精度)",{"$nulls":4},"位字段类型。M 表示每个值的位数，范围为 1～64。如果 M 被省略，默认值为 1。如果为 BIT(M) 列分配的值的长度小于 M 位，在值的左边用 0 填充。例如，为 BIT(6) 列分配一个值 b'101'，其效果与分配 b'000101' 相同"]
[]
[]
[]
["字符数据类型","CHAR(长度)",null,null,null,"NCHAR\nCHARACTER","0-255 bytes 定长字符串 固定长度非二进制字符串 M 字节，1<=M<=255"]
[null,"VARCHAR(长度)",null,null,null,"VARCHAR2\nNVARCHAR2\nBPCHAR","0-65535 bytes\t变长字符串 变长非二进制字符串 L+1字节，在此，L< = M和 1<=M<=255"]
[null,"TINYTEXT",{"$nulls":4},"0-255 bytes 短文本字符串"]
[null,"TEXT",null,null,null,"CLOB\nNCLOB\nROWID\nUROWID","0-65 535 bytes 长文本数据"]
[null,"MEDIUMTEXT",null,null,null,"LONGVARCHAR","0-16 777 215 bytes\t中等长度文本数据"]
[null,"LONGTEXT",{"$nulls":4},"0-4 294 967 295 bytes\t极大文本数据"]
[]
[]
[]
[]
[]
["二进制数据类型","BINARY(长度)",{"$nulls":4},"0-255 bytes 不超过 255 个字符的二进制字符串 固定长度二进制字符串 M 字节"]
[null,"VARBINARY(长度)",{"$nulls":4},"可变长度二进制字符串 M+1 字节"]
[null,"TINYBLOB",{"$nulls":4},"非常小的BLOB L+1 字节，在此，L<2^8"]
[null,"BLOB",null,null,null,"BFILE\nRAW\nBYTEA\nIF NOT FOUND","0-65 535 bytes 二进制形式的长文本数据 小 BLOB L+2 字节，在此，L<2^16"]
[null,"MEDIUMBLOB",{"$nulls":4},"0-16 777 215 bytes\t二进制形式的中等长度文本数据 中等大小的BLOB\tL+3 字节，在此，L<2^24"]
[null,"LONGBLOB",null,null,null,"LONG RAW","0-4 294 967 295 bytes\t二进制形式的极大文本数据 非常大的BLOB\tL+4 字节，在此，L<2^32"]
[]
[]
[]
[{"$nulls":6},"3 bytes 1000-01-01/9999-12-31 YYYY-MM-DD 日期值"]
["日期时间数据类型","DATE",{"$nulls":4},"3 bytes '-838:59:59'/'838:59:59' HH:MM:SS 时间值或持续时间"]
[null,"TIME",{"$nulls":4},"1 bytes 1901/2155 YYYY 年份值"]
[null,"YEAR",{"$nulls":4},"8 bytes '1000-01-01 00:00:00' 到 '9999-12-31 23:59:59' YYYY-MM-DD hh:mm:ss 混合日期和时间值"]
[null,"DATETIME",null,null,null,"DATETIME WITH TIME ZONE","4 bytes '1970-01-01 00:00:01' UTC 到 '2038-01-19 03:14:07' UTC 结束时间是第 2147483647 秒，北京时间 2038-1-19 11:14:07，格林尼治时间 2038年1月19日 凌晨 03:14:07 YYYY-MM-DD hh:mm:ss 混合日期和时间值，时间戳"]
[null,"TIMESTAMP",null,null,null,"TIMESTAMP WITH TIME ZONE\nTIMESTAMP WITH LOCAL TIME ZONE\nINTERVAL YEAR TO MONTH\nINTERVAL DAY TO SECOND\nTIME WITH TIME ZONE\nTIMESTAMP WITHOUT TIME ZONE"]
[]
[]
[]
[]
["枚举数据类型","ENUM",{"$nulls":4},"枚举类型，只能有一个枚举字符串值 1或2个字节，取决于枚举值的数目 (最大值为65535)"]
[null,"SET",{"$nulls":4},"一个设置，字符串对象可以有零个或 多个SET成员 1、2、3、4或8个字节，取决于集合 成员的数量（最多64个成员）"]
[]
[]
[]
[]
[]
["参照：https://www.runoob.com/mysql/mysql-data-types.html\nhttp://c.biancheng.net/view/2422.html"]

{"sheet":"Oracle","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[16,0,26,0],[1,0,5,0],[53,0,54,6],[37,0,45,0],[6,0,9,0],[10,0,15,0],[27,0,36,0],[46,0,50,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型"]
[null,"INTEGER",null,null,null,"TINYINT\nSMALLINT\nMEDIUMINT\nINT\nBIGINT\nBIT&&columnLength==1||columnPrecision==1\nINT1\nINT2\nINT4\nBOOL\nBOOLEAN","INTEGER是NUMBER的子类型，它等同于NUMBER（38,0），用来存储整数。若插入、更新的数值有小数，则会被四舍五入"]
[]
[]
[]
["浮点数据类型","FLOAT",null,null,null,"DOUBLE\nFLOAT4\nFLOAT8\nDOUBLE PRECISION","FLOAT类型也是NUMBER的子类型。\n\nFloat(n)，数n指示位的精度，可以存储的值的数目。n值的范围可以从 1 到 126。若要从二进制转换为十进制的精度，请将n乘以 0.30103。要从十进制转换为二进制的精度，请用3.32193乘小数精度。126位二进制精度的最大值是大约相当于38位小数精度"]
[]
[]
[]
["数值数据类型","NUMBER(P,S)",null,null,null,"DECIMAL\nDEC\nREAL\nNUMERIC\nINT8","NUMBER(P,S)是最常见的数字类型，可以存放数据范围为10^130~10^126（不包含此值)，需要1~22字节(BYTE)不等的存储空间。\n\nP 是Precison的英文缩写，即精度缩写，表示有效数字的位数，最多不能超过38个有效数字。\n\nS是Scale的英文缩写，可以使用的范围为-84~127。Scale为正数时，表示从小数点到最低有效数字的位数，它为负数时，表示从最大有效数字到小数点的位数。"]
[]
[]
[]
[]
[]
["字符数据类型","CHAR(L)",null,null,null,"CHARACTER","定长字符串，会用空格填充来达到其最大长度。非NULL的CHAR（12）总是包含12字节信息。CHAR字段最多可以存储2000字节的信息。如果创建表时，不指定CHAR长度，则默认为1。另外你可以指定它存储字节或字符，例如 CHAR(12 BYTYE)、CHAR(12 CHAR)。一般来说默认是存储字节"]
[null,"NCHAR(L)",{"$nulls":4},"一个包含UNICODE格式数据的定长字符串。NCHAR字段最多可以存储2000字节的信息，它的最大长度取决于国家字符集"]
[null,"VARCHAR2(L)",null,null,null,"VARCHAR\nBPCHAR","变长字符串，与CHAR类型不同，它不会使用空格填充至最大长度。VARCHAR2最多可以存储4000字节的信息"]
[null,"NVARCHAR2(L)",{"$nulls":4},"一个包含UNICODE格式数据的变长字符串，NVARCHAR2最多可以存储4000字节的信息"]
[null,"CLOB",null,null,null,"TINYTEXT\nTEXT\nMEDIUMTEXT\nLONGTEXT\nENUM\nSET\nLONGVARCHAR","CLOB存储单字节和多字节字符数据。支持固定宽度和可变宽度的字符集。CLOB对象可以存储最多 (4 gigabytes-1) * (database block size) 大小的字符"]
[null,"NCLOB",null,null,null,"BINARY\nVARBINARY\nTINYBLOB\nMEDIUMBLOB\nLONGBLOB","NCLOB存储UNICODE类型的数据，支持固定宽度和可变宽度的字符集，NCLOB对象可以存储最多(4 gigabytes-1) * (database block size)大小的文本数据"]
[null,"RAW(长度)",{"$nulls":4},"用于存储二进制或字符类型数据，变长二进制数据类型，这说明采用这种数据类型存储的数据不会发生字符集转换。这种类型最多可以存储2000字节的信息，建议使用 BLOB 来代替它"]
[]
[null,"ROWID",{"$nulls":4},"ROWID是一种特殊的列类型，称之为伪列（pseudocolumn）。ROWID伪列在SQL SELECT语句中可以像普通列那样被访问。ROWID表示行的地址，ROWID伪列用ROWID数据类型定义。Oracle数据库中每行都有一个伪列。\n\nROWID与磁盘驱动的特定位置有关，因此，ROWID是获得行的最快方法。但是，行的ROWID会随着卸载和重载数据库而发生变化，因此建议不要在事务中使用ROWID伪列的值。例如，一旦当前应用已经使用完记录，就没有理由保存行的ROWID。不能通过任何SQL语句来设置标准的ROWID伪列的值。\n\n列或变量可以定义成ROWID数据类型，但是Oracle不能保证该列或变量的值是一个有效的ROWID"]
[null,"UROWID",{"$nulls":4},"UROWID，它用于表，是行主键的一个表示，基于主键生成。UROWID与ROWID的区别就是UROWID可以表示各种ROWID，使用较安全。一般是索引组织表在使用UROWID"]
[]
["二进制数据类型"]
[]
[null,"BLOB",null,null,null,"BIT&&columnLength>1||columnPrecision>1\nBYTEA\nIF NOT FOUND","BLOB存储非结构化的二进制数据大对象，它可以被认为是没有字符集语义的比特流，一般是图像、声音、视频等文件。BLOB对象最多存储(4 gigabytes-1) * (database block size)的二进制数据"]
[null,"BFILE",{"$nulls":4},"二进制文件，存储在数据库外的系统文件，只读的，数据库会将该文件当二进制文件处理"]
[null,"LONG RAW",{"$nulls":4},"LONG RAW类型，能存储2GB的原始二进制数据（不用进行字符集转换的数据）。建议使用BLOB来代替它"]
[]
[]
[]
[]
[]
["日期时间数据类型","DATE",{"$nulls":4},"DATE是最常用的数据类型，日期数据类型存储日期和时间信息。虽然可以用字符或数字类型表示日期和时间信息，但是日期数据类型具有特殊关联的属性。为每个日期值，Oracle 存储以下信息： 世纪、 年、 月、 日期、 小时、 分钟和秒。一般占用7个字节的存储空间"]
[null,"TIMESTAMP",null,null,null,"TIME\nYEAR\nDATETIME","TIMESTAMP是一个7字节或12字节的定宽日期/时间数据类型，是DATE类型的扩展类型。它与DATE数据类型不同，因为TIMESTAMP可以包含小数秒，带小数秒的TIMESTAMP在小数点右边最多可以保留9位"]
[null,"TIMESTAMP WITH TIME ZONE",null,null,null,"DATETIME WITH TIME ZONE\nTIME WITH TIME ZONE\nTIMESTAMP WITHOUT TIME ZONE","和TIMESTAMP一样，只不过可以在设置时候指定时区"]
[null,"TIMESTAMP WITH LOCAL TIME ZONE"]
[null,null,"INTERVAL YEAR TO MONTH",null,null,"INTERVAL YEAR*","记录两个DATE或TIMESTAMP之间的以年和月的时间间隔"]
[null,null,"INTERVAL DAY TO SECOND",null,null,"INTERVAL DAY*","记录两个DATE或TIMESTAMP之间的以天和秒的时间间隔"]
[]
[]
[]
["其它数据类型"]
[]
[]
[]
[]
[]
[]
["参照：https://www.cnblogs.com/janus2003/p/15072505.html\nhttps://blog.csdn.net/wuya814070935/article/details/73163604"]

{"sheet":"达梦","index":2,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[[1,0,10,0],[68,0,72,0],[21,0,29,0],[37,0,42,0],[43,0,67,0],[75,0,76,6],[11,0,20,0],[30,0,36,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","BIT",{"$nulls":4},"BIT 类型用于存储整数数据 1、0 或 NULL"]
[null,"INTEGER",null,null,null,"MEDIUMINT\nINT4","用于存储有符号整数，精度为 10，标度为 0。取值范围为：-2147483648(-2^31)～+2147483647(2^31-1)"]
[null,"INT",{"$nulls":4},"同上"]
[null,"PLS_INTEGER",{"$nulls":4},"同上"]
[null,"BIGINT",null,null,null,"INT8","用于存储有符号整数，精度为 19，标度为 0。取值范围为：-9223372036854775808(-2^63)～+9223372036854775807(2^63-1)"]
[null,"TINYINT",null,null,null,"INT1\nBOOL\nBOOLEAN","储有符号整数，精度为 3，标度为 0。取值范围为：-128～+127 "]
[null,"SMALLINT",null,null,null,"INT2","用于存储有符号整数，精度为 5，标度为 0。取值范围为：-32768(-2^15)~ +32767(2^15-1)"]
[]
[]
[]
["浮点数据类型","REAL",{"$nulls":4},"REAL 是带二进制的浮点数，但它不能由用户指定使用的精度，系统指定其二进制精度为 24，十进制精度为 7。取值范围-3.4E+38～3.4E + 38 "]
[null,"FLOAT","Y",null,null,"FLOAT4","FLOAT 是带二进制精度的浮点数，精度最大不超过 53，如省略精度，则二进制精度为 53，十进制精度为 15。取值范围为-1.7E+308～1.7E+308"]
[null,"DOUBLE","Y",null,null,"FLOAT8","同 FLOAT 相似，精度最大不超过 53"]
[null,"DOUBLE PRECISION",{"$nulls":4},"该类型指明双精度浮点数，其二进制精度为 53，十进制精度为 15。取值范围-1.7E+308 ～1.7E+308"]
[]
[]
[]
[]
[]
[]
["数值数据类型","NUMERIC( 精度 , 标度)","Y","Y",null,null,"精度是一个无符号整数，定义了总的数字数，精度范围是 1~38 ，标度定义了小数点右边的数字位数，一个数的标度不应大于其精度"]
[null,"NUMBER(精度 , 标度)","Y","Y",null,null,"同上"]
[null,"DECIMAL( 精度 , 标度)","Y","Y",null,"REAL","同上"]
[null,"DEC( 精度 , 标度)","Y","Y",null,null,"同上"]
[]
[]
[]
[]
[]
["字符数据类型","CHAR(长度)",null,null,"Y","NCHAR","定长字符串，最大长度由数据库页面大小决定，具体可参考《DM8_SQL 语言使用手册》1.4.1 节。长度不足时，自动填充空格"]
[null,"CHARACTER(长度)",null,null,"Y",null,"同上"]
[null,"VARCHAR(长度)",null,null,"Y","VARCHAR2\nNVARCHAR2\nBPCHAR","可变长字符串，最大长度由数据库页面大小决定"]
[null,"TEXT",{"$nulls":4},"变长字符串类型，其字符串的长度最大为 100G-1，可用于存储长的文本串"]
[null,null,"LONGVARCHAR",null,null,null,"同上"]
[null,"CLOB",null,null,null,"TINYTEXT\nMEDIUMTEXT\nLONGTEXT\nSET\nENUM\nNCLOB\nROWID\nUROWID","CLOB 类型用于指明变长的字符串，长度最大为 100G-1 字节"]
[]
["二进制数据类型","BLOB",null,null,null,"BINARY\nVARBINARY\nTINYBLOB\nMEDIUMBLOB\nLONGBLOB\nRAW\nLONG RAW\nBYTEA\nIF NOT FOUND","BLOB 类型用于指明变长的二进制大对象，长度最大为 100G-1 字节"]
[null,"BFILE",{"$nulls":4},"BFILE 用于指明存储在操作系统中的二进制文件，文件存储在操作系统而非数据库中，仅能进行只读访问"]
[null,"BINARY(长度 )",null,null,"Y",null,"BINARY 数据类型指定定长二进制数据。缺省长度为 1 个字节"]
[null,"VARBINARY(长度 )",null,null,"Y",null,"VARBINARY 数据类型指定变长二进制数据，用法类似 BINARY 数据类型，可以指定一个正整数作为数据长度。缺省长度为 8188 个字节，最大长度由数据库页面大小决定"]
[]
[]
["日期时间数据类型","DATE",{"$nulls":4},"DATE 类型包括年、月、日信息，定义了'-4712-01-01'和'9999-12-31'之间任何一个有效的格里高利日期"]
[null,"TIME","Y",null,null,null,"IME 类型包括时、分、秒信息，定义了一个在'00:00:00.000000'和'23:59:59.999999'之间的有效时间。TIME 类型的小数秒精度规定了秒字段中小数点后面的位数，取值范围为 0～6，如果未定义，缺省精度为 0"]
[null,"TIMESTAMP","Y",null,null,"YEAR","TIMESTAMP/DATETIME 类型包括年、月、日、时、分、秒信息，定义了一个在'-4712-01-0100:00:00.000000'和'9999-12-31 23:59:59.999999'之间的有效格里高利日期时间。小数秒精度规定了秒字段中小数点后面的位数，取值范围为 0～6，如果未定义，缺省精度为 6"]
[null,"DATETIME","Y",null,null,null,"同上"]
[null,"DATETIME WITH TIME ZONE"]
[null,"TIME WITH TIME ZONE","Y",null,null,"TIMESTAMP WITHOUT TIME ZONE","描述一个带时区的 TIME 值，其定义是在 TIME 类型的后面加上时区信息。时区部分的实质是 INTERVAL HOUR TO MINUTE 类型，取值范围：-12:59 与 +14:00 之间。例如：TIME '09:10:21 +8:00'"]
[null,"TIMESTAMP WITH TIME ZONE","Y",null,null,null,"描述一个带时区的 TIMESTAMP 值，其定义是在 TIMESTAMP 类型的后面加上时区信息。时区部分的实质是 INTERVAL HOUR TO MINUTE 类型，取值范围：-12:59 与 +14:00 之间。例如：’2009-10-11 19:03:05.0000 -02:10’"]
[null,"TIMESTAMP WITH LOCAL TIME ZONE","Y",null,null,null,"描述一个本地时区的 TIMESTAMP 值，能够将标准时区类型 TIMESTAMP WITH TIME ZONE 类型转化为本地时区类型，如果插入的值没有指定时区，则默认为本地时区。"]
[null,null,"INTERVAL YEAR",null,null,null,"年间隔，即两个日期之间的年数字，P 为时间间隔的首项字段精度(后面简称为：首精度)"]
[null,null,"INTERVAL DAY",null,null,null,"月间隔，即两个日期之间的月数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL MONTH",null,null,null,"日间隔，即为两个日期/时间之间的日数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL HOUR",null,null,null,"时间隔，即为两个日期/时间之间的时数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL MINUTE",null,null,null,"分间隔，即为两个日期/时间之间的分数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL SECOND",null,null,null,"秒间隔，即为两个日期/时间之间的秒数字，P 为时间间隔的首精度，Q 为时间间隔秒精度"]
[null,null,"INTERVAL YEAR TO MONTH",null,null,null,"年月间隔，即两个日期之间的年月数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL DAY TO HOUR",null,null,null,"日时间隔，即为两个日期/时间之间的日时数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL DAY TO MINUTE",null,null,null,"日时分间隔，即为两个日期/时间之间的日时分数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL DAY TO SECOND",null,null,null,"日时分秒间隔，即为两个日期/时间之间的日时分秒数字，P 为时间间隔的首精度，Q 为时间间隔秒精度"]
[null,null,"INTERVAL HOUR TO MINUTE",null,null,null,"时分间隔，即为两个日期/时间之间的时分数字，P 为时间间隔的首精度"]
[null,null,"INTERVAL HOUR TO SECOND",null,null,null,"时分秒间隔，即为两个日期/时间之间的时分秒数字，P 为时间间隔的首精度，Q 为时间间隔秒精度"]
[null,null,"INTERVAL MINUTE TO SECOND",null,null,null,"分秒间隔，即为两个日期/时间之间的分秒间隔，P 为时间间隔的首精度，Q 为时间间隔秒精度"]
[]
[]
[]
[]
["布尔数据类型"]
[]
[]
[]
[]
[]
[]
["参照：https://eco.dameng.com/document/dm/zh-cn/pm/dm8_sql-data-types-operators.html"]

{"sheet":"金仓","index":3,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,10,0],[18,0,23,0],[51,0,55,0],[35,0,42,0],[24,0,34,0],[56,0,60,0],[43,0,50,0],[11,0,17,0],[63,0,64,6]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","TINYINT",null,null,null,"BIT&&columnLength==1||columnPrecision==1","有符号整数，取值范围 -128 ~ +127"]
[null,"SMALLINT",{"$nulls":4},"有符号整数，取值范围 -32768 ~ +32767"]
[null,"INTEGER",null,null,null,"MEDIUMINT","有符号整数，取值范围 -2147483648~ +2147483647"]
[null,"INT",null,null,null,"INT1\nINT2\nINT4","同上"]
[null,"BIGINT",null,null,null,"INT8","有符号整数，取值范围 -9223372036854775808~ +9223372036854775807"]
[null,"SMALLSERIAL",{"$nulls":4},"相当于创建一个SMALLINT列"]
[null,"SERIAL",{"$nulls":4},"相当于创建一个INT列"]
[null,"BIGSERIAL",{"$nulls":4},"相当于创建一个BIGINT列"]
[]
[]
["浮点数据类型","REAL",{"$nulls":4},"范围在 -1E+37 到 +1E+37 之间，精度至少是 6 位小数"]
[null,"DOUBLE PRECISION",{"$nulls":4},"范围在 -1E+37 到 +1E+37 之间，精度至少是15位小数"]
[null,"FLOAT",null,null,null,"DOUBLE\nFLOAT4\nFLOAT8","当p取值为1-24时，与REAL相同。当p取值为25-53时，与DOUBLE PRECISION相同。 没有指定精度时，与DOUBLE PRECISION相同"]
[]
[]
[]
[]
["数值数据类型","NUMERIC(precision, scale)",null,null,null,"REAL","存储0 以及绝对值为[1.0 x 10-130, 1.0 x 10126)的正、负定点数。 在算术运算中，如果超出范围，KingbaseE报错。\n\nprecision表示精度，是整个数中有效位的总数，也就是小数点两边的位数。取值范围为 1~1000。 scale表示标度，是小数部分的数字位数，也就是小数点右边的部分。取值范围为0~1000。\n\n使用该数据类型时，最好指定定点数的小数位数和精度，以便在输入时进行额外的完整性检查。 指定小数位数和精度不会强制所有值都达到固定长度。如果某个值超过精度，KingbaseES将返回错误。如果某个值超过标度，KingbaseES会对其进行四舍五入。\n\n也可以使用NUMERIC(precision) 类型，即标度为0的定点数，即NUMERIC(precision, 0)\n\n也可以直接使用NUMERIC类型，缺省精度和标度，指定KingbaseES数值的最大精度和标度。 考虑到移植性，在使用时最好是显式声明精度和标度。\n————————————————\n版权声明：本文为CSDN博主「沉舟侧畔千帆过_」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。\n原文链接：https://blog.csdn.net/arthemis_14/article/details/125843469"]
[null,"DECIMAL(precision, scale)",null,null,null,"DEC","同上"]
[null,"NUMBER(precision, scale)",{"$nulls":4},"同上"]
[]
[]
[]
["字符数据类型","CHAR(长度)",null,null,null,"NCHAR\nCHARACTER"]
[null,"VARCHAR(长度)",null,null,null,"VARCHAR2\nNVARCHAR2\nBPCHAR"]
[null,"CHARACTER(长度)",null,null,null,"CHARACTER VARYING"]
[]
[null,"CLOB",null,null,null,"TINYTEXT\nMEDIUMTEXT\nLONGTEXT\nSET\nENUM\nNCLOB\nROWID\nUROWID\nLONGVARCHAR"]
[null,"TEXT"]
[]
[]
[]
[]
[]
["二进制数据类型","BLOB",null,null,null,"BINARY\nVARBINARY\nTINYBLOB\nMEDIUMBLOB\nLONGBLOB\nBFILE\nRAW\nLONG RAW\nBIT&&columnLength>1||columnPrecision>1\nIF NOT FOUND"]
[null,"BYTEA"]
[]
[]
[]
[]
[]
[]
["日期时间数据类型","DATE"]
[null,"TIMESTAMP",null,null,null,"YEAR\nDATETIME\nTIME"]
[null,"TIMESTAMP WITHOUT TIME ZONE",null,null,null,"TIMESTAMP WITH TIME ZONE\nTIMESTAMP WITH LOCAL TIME ZONE\nDATETIME WITH TIME ZONE\nTIME WITH TIME ZONE"]
[null,null,"INTERVAL"]
[null,null,"INTERVAL DAY TO SECOND"]
[null,null,"INTERVAL YEAR TO MONTH"]
[]
[]
["布尔数据类型","BOOL",{"$nulls":4},"布尔数据类型：TRUE 和 FALSE。DMSQL 程序的布尔类型和 INT 类型可以相互转化。如果变量或方法返回的类型是布尔类型，则返回值为 0 或 1。TRUE 和非 0 值的返回值为 1，FALSE 和 0 值返回为 0"]
[null,"BOOLEAN",{"$nulls":4},"同上"]
[]
[]
[]
["其它数据类型"]
[]
[]
[]
[]
[]
[]
["参照："]

{"sheet":"神通","index":4,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,10,0],[36,0,45,0],[20,0,26,0],[55,0,59,0],[11,0,19,0],[27,0,35,0],[46,0,54,0],[63,0,64,6]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","TINYINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<3)||(columnPrecision>0&&columnPrecision<3))\nBIT&&columnLength==1||columnPrecision==1"]
[null,"INT",null,null,null,"SMALLINT\nMEDIUMINT\nNUMBER&&columnScale==0&&((columnLength>0&&columnLength<11)||(columnPrecision>0&&columnPrecision<11))"]
[null,"INTEGER"]
[null,"INT1"]
[null,"INT2"]
[null,"INT4"]
[null,"INT8",null,null,null,"BIGINT\nNUMBER&&columnScale==0"]
[]
[]
[]
["浮点数据类型","FLOAT4"]
[null,"FLOAT8",null,null,null,"DOUBLE\nFLOAT\nDOUBLE PRECISION"]
{"$rows_empty":7}
["数值数据类型","NUMERIC(precision, scale)",null,null,null,"REAL"]
[null,"DECIMAL(precision, scale)",null,null,null,"DEC\nNUMBER"]
[null,"SERIAL"]
[]
[]
[]
[]
["字符数据类型","CHAR(长度)",null,null,null,"NCHAR\nCHARACTER"]
[null,"VARCHAR(长度)",null,null,null,"VARCHAR2\nNVARCHAR2"]
[null,"BPCHAR(长度)"]
[null,"CLOB",null,null,null,"TINYTEXT\nMEDIUMTEXT\nLONGTEXT\nENUM\nSET\nNCLOB\nROWID\nUROWID\nLONGVARCHAR"]
[null,"TEXT"]
[]
[]
[]
[]
["二进制数据类型"]
[null,"BLOB",null,null,null,"BINARY\nVARBINARY\nTINYBLOB\nMEDIUMBLOB\nLONGBLOB\nRAW\nLONG RAW\nBIT&&columnLength>1||columnPrecision>1\nBYTEA\nIF NOT FOUND"]
[null,"BFILE"]
[null,null,"BINARY(长度)"]
[null,null,"VARBINARY(长度)"]
[]
[]
[]
[]
[]
["日期时间数据类型","DATE"]
[null,"TIME"]
[null,"TIMESTAMP",null,null,null,"YEAR\nDATETIME\nTIMESTAMP WITH TIME ZONE\nTIMESTAMP WITH LOCAL TIME ZONE\nINTERVAL YEAR TO MONTH\nINTERVAL DAY TO SECOND\nDATETIME WITH TIME ZONE\nTIME WITH TIME ZONE\nTIMESTAMP WITHOUT TIME ZONE"]
[]
[]
[]
[]
[]
[]
["布尔数据类型","BOOL",{"$nulls":4},"布尔数据类型：TRUE 和 FALSE。DMSQL 程序的布尔类型和 INT 类型可以相互转化。如果变量或方法返回的类型是布尔类型，则返回值为 0 或 1。TRUE 和非 0 值的返回值为 1，FALSE 和 0 值返回为 0"]
[null,"BOOLEAN",{"$nulls":4},"同上"]
[]
[]
[]
[]
[]
[]
["参照：http://www.4k8k.xyz/article/lmfxiaohuo/104036786"]

{"sheet":"Sqlite","index":5,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[48,0,59,0],[1,0,6,0],[18,0,34,0],[67,0,68,6],[35,0,47,0],[7,0,9,0],[10,0,13,0],[60,0,64,0],[14,0,17,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","TINYINT(长度)",null,null,null,"INT1"]
[null,"SMALLINT(长度)",null,null,null,"INT2"]
[null,"MEDIUMINT(长度)"]
[null,"INT(长度)",null,null,null,"INT4"]
[null,"INTEGER(长度)"]
[null,"BIGINT(长度)",null,null,null,"INT8"]
["浮点数据类型","FLOAT",null,null,null,"FLOAT4"]
[null,"DOUBLE",null,null,null,"FLOAT8\nDOUBLE PRECISION"]
[null,"REAL"]
["定点数据类型","DECIMAL(精度,标度)"]
[null,"DEC(精度,标度)"]
[null,"NUMBER(precision, scale)"]
[null,"NUMERIC(precision, scale)",{"$nulls":4},"当文本数据被插入到亲缘性为NUMERIC的字段中时，如果转换操作不会导致数据信息丢失以及完全可逆，那么SQLite就会将该文本数据转换为INTEGER或REAL类型的数据，如果转换失败，SQLite仍会以TEXT方式存储该数据。对于NULL或BLOB类型的新数据，SQLite将不做任何转换，直接以NULL或BLOB的方式存储该数据。需要额外说明的是，对于浮点格式的常量文本，如\"30000.0\"，如果该值可以转换为INTEGER同时又不会丢失数值信息，那么SQLite就会将其转换为INTEGER的存储方式。"]
["位数据类型","BIT(M)"]
[]
[]
[]
["字符数据类型","CHAR(M)",null,null,null,"CHARACTER"]
[null,"VARCHAR(M)",null,null,null,"SET\nBPCHAR"]
[null,"TINYTEXT"]
[null,"TEXT",{"$nulls":4},"值是一个文本字符串，使用数据库编码（UTF-8、UTF-16BE 或 UTF-16LE）存储。"]
[null,"MEDIUMTEXT"]
[null,"LONGTEXT",null,null,null,"LONGVARCHAR"]
[null,"ENUM"]
[null,"NCHAR(L)"]
[null,"VARCHAR2(L)"]
[null,"NVARCHAR2(L)"]
[null,"CLOB(L)"]
[null,"NCLOB(L)"]
[]
[null,"RAW(长度)"]
[null,"ROWID"]
[null,"UROWID"]
[]
["二进制数据类型","BINARY(M)"]
[null,"VARBINARY(M)"]
[null,"TINYBLOB"]
[null,"BLOB",null,null,null,"IF NOT FOUND"]
[null,"MEDIUMBLOB"]
[null,"LONGBLOB"]
[null,"BFILE"]
[]
[null,"LONG RAW"]
[]
[]
[null,"BYTEA"]
[]
["日期时间数据类型","DATE"]
[null,"TIME"]
[null,"YEAR"]
[null,"DATETIME"]
[null,"TIMESTAMP",null,null,null,"INTERVAL YEAR TO MONTH\nINTERVAL DAY TO SECOND"]
[null,"TIMESTAMP WITH TIME ZONE",null,null,null,"TIMESTAMP WITHOUT TIME ZONE"]
[null,"TIMESTAMP WITH LOCAL TIME ZONE"]
[null,"TIME WITH TIME ZONE"]
[null,"DATETIME WITH TIME ZONE"]
[]
[]
[]
["其他数据类型","BOOL"]
[null,"BOOLEAN"]
[]
[]
[]
[]
[]
["参照：https://www.runoob.com/sqlite/sqlite-data-types.html"]

{"sheet":"GBase","index":6,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[16,0,26,0],[1,0,8,0],[37,0,45,0],[53,0,54,6],[9,0,13,0],[27,0,36,0],[46,0,50,0],[14,0,15,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","INT",{"$nulls":4},"整数 -2,147,483,647 至 2,147,483,647"]
[null,"INTEGER",null,null,null,"TINYINT\nMEDIUMINT\nINT&&columnScale==0&&((columnLength>0&&columnLength<11)||(columnPrecision>0&&columnPrecision<11))\nBIT&&columnLength==1||columnPrecision==1\nINT1\nINT2\nINT4\nBOOL\nBOOLEAN"]
[null,"BIGINT",null,null,null,"INT8\nINT&&columnScale==0&&((columnLength>=11)||(columnPrecision<=11))"]
[null,"SERIAL",{"$nulls":4},"自增类型，默认从1开始。可以设置初始值，如：serial(n)"]
[null,"SERIAL8",{"$nulls":4},"自增类型，默认从1开始。可以设置初始值，如：serial(n)"]
[null,"SMALLINT"]
[]
[]
["浮点数据类型","FLOAT",null,null,null,"DOUBLE\nFLOAT4\nFLOAT8\nDOUBLE PRECISION","双精度浮点数值 存储最多带有 16 位有效数字的双精度浮点数值"]
[null,"SMALLFLOAT"]
[null,"REAL"]
[]
[]
["定点数据类型","DECIMAL(p,s)",null,null,null,"DECIMAL\nDEC\nREAL\nNUMERIC","存储实数的定点小数值 在小数部分中最多 20 位有效数字，或在小数点的左边最多 32 位有效数字。"]
[null,"NUMERIC(p,s)",{"$nulls":4},"DECIMAL(p,s) 的符合 ANSI 的同义词 p最大精度是38位(十进制)"]
["字符数据类型","CHAR(长度)",null,null,null,"CHARACTER"]
[null,"NCHAR(长度)"]
[null,"VARCHAR(长度)",null,null,null,"VARCHAR2\nBPCHAR"]
[null,"LVARCHAR(长度)"]
[null,"NVARCHAR(长度)",null,null,null,"NVARCHAR2"]
[null,"TEXT"]
[null,"CLOB",null,null,null,"TINYTEXT\nMEDIUMTEXT\nLONGTEXT\nSET\nENUM\nNCLOB\nROWID\nUROWID"]
[]
[]
[]
[]
["二进制数据类型","BLOB",null,null,null,"BINARY\nVARBINARY\nTINYBLOB\nMEDIUMBLOB\nLONGBLOB\nRAW\nLONG RAW\nBYTEA\nIF NOT FOUND"]
[null,"BYTE"]
{"$rows_empty":8}
["日期时间数据类型","DATE",{"$nulls":4},"YYYY-MM-DD 1 年 1 月 1 日直至 9999 年 12 月 31 日"]
[null,"DATETIME",{"$nulls":4},"（年、月、日）和每日时间（小时、分、秒和几分之一秒） 1 年至 9999 年"]
[null,"INTERVAL"]
[]
[]
[]
[]
[]
[]
["布尔数据类型","BOOLEAN"]
[]
[]
[]
[]
[]
[]
["参照：http://www.4k8k.xyz/article/lmfxiaohuo/104036786"]

{"sheet":"OpenGauss","index":7,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,6,0],[36,0,44,0],[52,0,53,6],[7,0,8,0],[9,0,10,0],[26,0,35,0],[11,0,14,0],[45,0,49,0],[15,0,25,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","TINYINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<3)||(columnPrecision>0&&columnPrecision<3))\nINT1\nBOOL\nBOOLEAN","1 Bytes 范围（有符号）(-128，127) 范围（无符号）(0，255) 小整数值"]
[null,"SMALLINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<6)||(columnPrecision>0&&columnPrecision<6))\nINT2","2 Bytes 范围（有符号）(-32 768，32 767) 范围（无符号）(0，65 535)  大整数值"]
[null,"MEDIUMINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<9)||(columnPrecision>0&&columnPrecision<9))","3 Bytes 范围（有符号）(-8 388 608，8 388 607) 范围（无符号）(0，16 777 215)  大整数值"]
[null,"INT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<11)||(columnPrecision>0&&columnPrecision<11))\nINT4","4 Bytes 范围（有符号）(-2 147 483 648，2 147 483 647) 范围（无符号）(0，4 294 967 295)  大整数值"]
[null,"INTEGER",{"$nulls":4},"同上"]
[null,"BIGINT",null,null,null,"NUMBER&&columnScale==0\nINT8","8 Bytes 范围（有符号）(-9,223,372,036,854,775,808，9 223 372 036 854 775 807) 范围（无符号）(0，18 446 744 073 709 551 615)  极大整数值"]
["浮点数据类型","FLOAT",null,null,null,"FLOAT4","4 Bytes 范围（有符号）(-3.402 823 466 E+38，-1.175 494 351 E-38)，0，(1.175 494 351 E-38，3.402 823 466 351 E+38) 范围（无符号）0，(1.175 494 351 E-38，3.402 823 466 E+38)  单精度 浮点数值"]
[null,"DOUBLE",null,null,null,"FLOAT8\nDOUBLE PRECISION","8 Bytes 范围（有符号）(-1.797 693 134 862 315 7 E+308，-2.225 073 858 507 201 4 E-308)，0，(2.225 073 858 507 201 4 E-308，1.797 693 134 862 315 7 E+308)范围（无符号）0，(2.225 073 858 507 201 4 E-308，1.797 693 134 862 315 7 E+308)  双精度 浮点数值"]
["定点数据类型","DECIMAL(精度,标度)",null,null,null,"NUMBER\nREAL\nNUMERIC","对DECIMAL(M,D) ，如果M>D，为M+2 否则为D+2 小数值"]
[null,"DEC(精度,标度)",{"$nulls":4},"同上"]
["位数据类型","BIT(精度)",{"$nulls":4},"位字段类型。M 表示每个值的位数，范围为 1～64。如果 M 被省略，默认值为 1。如果为 BIT(M) 列分配的值的长度小于 M 位，在值的左边用 0 填充。例如，为 BIT(6) 列分配一个值 b'101'，其效果与分配 b'000101' 相同"]
[]
[]
[]
["字符数据类型","CHAR(长度)",null,null,null,"NCHAR\nCHARACTER","0-255 bytes 定长字符串 固定长度非二进制字符串 M 字节，1<=M<=255"]
[null,"VARCHAR(长度)",null,null,null,"VARCHAR2\nNVARCHAR2\nBPCHAR","0-65535 bytes\t变长字符串 变长非二进制字符串 L+1字节，在此，L< = M和 1<=M<=255"]
[null,"TINYTEXT",{"$nulls":4},"0-255 bytes 短文本字符串"]
[null,"TEXT",null,null,null,"CLOB\nNCLOB\nROWID\nUROWID","0-65 535 bytes 长文本数据"]
[null,"MEDIUMTEXT",null,null,null,"LONGVARCHAR","0-16 777 215 bytes\t中等长度文本数据"]
[null,"LONGTEXT",{"$nulls":4},"0-4 294 967 295 bytes\t极大文本数据"]
[]
[]
[]
[]
[]
["二进制数据类型","BINARY(长度)",{"$nulls":4},"0-255 bytes 不超过 255 个字符的二进制字符串 固定长度二进制字符串 M 字节"]
[null,"VARBINARY(长度)",{"$nulls":4},"可变长度二进制字符串 M+1 字节"]
[null,"TINYBLOB",{"$nulls":4},"非常小的BLOB L+1 字节，在此，L<2^8"]
[null,"BLOB",null,null,null,"BFILE\nRAW\nBYTEA\nIF NOT FOUND","0-65 535 bytes 二进制形式的长文本数据 小 BLOB L+2 字节，在此，L<2^16"]
[null,"MEDIUMBLOB",{"$nulls":4},"0-16 777 215 bytes\t二进制形式的中等长度文本数据 中等大小的BLOB\tL+3 字节，在此，L<2^24"]
[null,"LONGBLOB",null,null,null,"LONG RAW","0-4 294 967 295 bytes\t二进制形式的极大文本数据 非常大的BLOB\tL+4 字节，在此，L<2^32"]
[]
[]
[]
[{"$nulls":6},"3 bytes 1000-01-01/9999-12-31 YYYY-MM-DD 日期值"]
["日期时间数据类型","DATE",{"$nulls":4},"3 bytes '-838:59:59'/'838:59:59' HH:MM:SS 时间值或持续时间"]
[null,"TIME",{"$nulls":4},"1 bytes 1901/2155 YYYY 年份值"]
[null,"YEAR",{"$nulls":4},"8 bytes '1000-01-01 00:00:00' 到 '9999-12-31 23:59:59' YYYY-MM-DD hh:mm:ss 混合日期和时间值"]
[null,"DATETIME",null,null,null,"DATETIME WITH TIME ZONE","4 bytes '1970-01-01 00:00:01' UTC 到 '2038-01-19 03:14:07' UTC 结束时间是第 2147483647 秒，北京时间 2038-1-19 11:14:07，格林尼治时间 2038年1月19日 凌晨 03:14:07 YYYY-MM-DD hh:mm:ss 混合日期和时间值，时间戳"]
[null,"TIMESTAMP",null,null,null,"TIMESTAMP WITH TIME ZONE\nTIMESTAMP WITH LOCAL TIME ZONE\nINTERVAL YEAR TO MONTH\nINTERVAL DAY TO SECOND\nTIME WITH TIME ZONE\nTIMESTAMP WITHOUT TIME ZONE"]
[]
[]
[]
[]
["枚举数据类型","ENUM",{"$nulls":4},"枚举类型，只能有一个枚举字符串值 1或2个字节，取决于枚举值的数目 (最大值为65535)"]
[null,"SET",{"$nulls":4},"一个设置，字符串对象可以有零个或 多个SET成员 1、2、3、4或8个字节，取决于集合 成员的数量（最多64个成员）"]
[]
[]
[]
[]
[]
["参照：https://www.runoob.com/mysql/mysql-data-types.html\nhttp://c.biancheng.net/view/2422.html"]

{"sheet":"Postgresql","index":8,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,6,0],[36,0,44,0],[52,0,53,6],[7,0,8,0],[9,0,10,0],[26,0,35,0],[11,0,14,0],[45,0,49,0],[15,0,25,0]]}
["类型","名称","精度","标度","长度","匹配","说明"]
["整型数据类型","TINYINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<3)||(columnPrecision>0&&columnPrecision<3))\nINT1\nBOOL\nBOOLEAN","1 Bytes 范围（有符号）(-128，127) 范围（无符号）(0，255) 小整数值"]
[null,"SMALLINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<6)||(columnPrecision>0&&columnPrecision<6))\nINT2","2 Bytes 范围（有符号）(-32 768，32 767) 范围（无符号）(0，65 535)  大整数值"]
[null,"MEDIUMINT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<9)||(columnPrecision>0&&columnPrecision<9))","3 Bytes 范围（有符号）(-8 388 608，8 388 607) 范围（无符号）(0，16 777 215)  大整数值"]
[null,"INT",null,null,null,"NUMBER&&columnScale==0&&((columnLength>0&&columnLength<11)||(columnPrecision>0&&columnPrecision<11))\nINT4","4 Bytes 范围（有符号）(-2 147 483 648，2 147 483 647) 范围（无符号）(0，4 294 967 295)  大整数值"]
[null,"INTEGER",{"$nulls":4},"同上"]
[null,"BIGINT",null,null,null,"NUMBER&&columnScale==0\nINT8","8 Bytes 范围（有符号）(-9,223,372,036,854,775,808，9 223 372 036 854 775 807) 范围（无符号）(0，18 446 744 073 709 551 615)  极大整数值"]
["浮点数据类型","FLOAT",null,null,null,"FLOAT4","4 Bytes 范围（有符号）(-3.402 823 466 E+38，-1.175 494 351 E-38)，0，(1.175 494 351 E-38，3.402 823 466 351 E+38) 范围（无符号）0，(1.175 494 351 E-38，3.402 823 466 E+38)  单精度 浮点数值"]
[null,"DOUBLE",null,null,null,"FLOAT8\nDOUBLE PRECISION","8 Bytes 范围（有符号）(-1.797 693 134 862 315 7 E+308，-2.225 073 858 507 201 4 E-308)，0，(2.225 073 858 507 201 4 E-308，1.797 693 134 862 315 7 E+308)范围（无符号）0，(2.225 073 858 507 201 4 E-308，1.797 693 134 862 315 7 E+308)  双精度 浮点数值"]
["定点数据类型","DECIMAL(精度,标度)",null,null,null,"NUMBER\nREAL\nNUMERIC","对DECIMAL(M,D) ，如果M>D，为M+2 否则为D+2 小数值"]
[null,"DEC(精度,标度)",{"$nulls":4},"同上"]
["位数据类型","BIT(精度)",{"$nulls":4},"位字段类型。M 表示每个值的位数，范围为 1～64。如果 M 被省略，默认值为 1。如果为 BIT(M) 列分配的值的长度小于 M 位，在值的左边用 0 填充。例如，为 BIT(6) 列分配一个值 b'101'，其效果与分配 b'000101' 相同"]
[]
[]
[]
["字符数据类型","CHAR(长度)",null,null,null,"NCHAR\nCHARACTER","0-255 bytes 定长字符串 固定长度非二进制字符串 M 字节，1<=M<=255"]
[null,"VARCHAR(长度)",null,null,null,"VARCHAR2\nNVARCHAR2\nBPCHAR","0-65535 bytes\t变长字符串 变长非二进制字符串 L+1字节，在此，L< = M和 1<=M<=255"]
[null,"TINYTEXT",{"$nulls":4},"0-255 bytes 短文本字符串"]
[null,"TEXT",null,null,null,"CLOB\nNCLOB\nROWID\nUROWID","0-65 535 bytes 长文本数据"]
[null,"MEDIUMTEXT",null,null,null,"LONGVARCHAR","0-16 777 215 bytes\t中等长度文本数据"]
[null,"LONGTEXT",{"$nulls":4},"0-4 294 967 295 bytes\t极大文本数据"]
[]
[]
[]
[]
[]
["二进制数据类型","BINARY(长度)",{"$nulls":4},"0-255 bytes 不超过 255 个字符的二进制字符串 固定长度二进制字符串 M 字节"]
[null,"VARBINARY(长度)",{"$nulls":4},"可变长度二进制字符串 M+1 字节"]
[null,"TINYBLOB",{"$nulls":4},"非常小的BLOB L+1 字节，在此，L<2^8"]
[null,"BLOB",null,null,null,"BFILE\nRAW\nBYTEA\nIF NOT FOUND","0-65 535 bytes 二进制形式的长文本数据 小 BLOB L+2 字节，在此，L<2^16"]
[null,"MEDIUMBLOB",{"$nulls":4},"0-16 777 215 bytes\t二进制形式的中等长度文本数据 中等大小的BLOB\tL+3 字节，在此，L<2^24"]
[null,"LONGBLOB",null,null,null,"LONG RAW","0-4 294 967 295 bytes\t二进制形式的极大文本数据 非常大的BLOB\tL+4 字节，在此，L<2^32"]
[]
[]
[]
[{"$nulls":6},"3 bytes 1000-01-01/9999-12-31 YYYY-MM-DD 日期值"]
["日期时间数据类型","DATE",{"$nulls":4},"3 bytes '-838:59:59'/'838:59:59' HH:MM:SS 时间值或持续时间"]
[null,"TIME",{"$nulls":4},"1 bytes 1901/2155 YYYY 年份值"]
[null,"YEAR",{"$nulls":4},"8 bytes '1000-01-01 00:00:00' 到 '9999-12-31 23:59:59' YYYY-MM-DD hh:mm:ss 混合日期和时间值"]
[null,"DATETIME",null,null,null,"DATETIME WITH TIME ZONE","4 bytes '1970-01-01 00:00:01' UTC 到 '2038-01-19 03:14:07' UTC 结束时间是第 2147483647 秒，北京时间 2038-1-19 11:14:07，格林尼治时间 2038年1月19日 凌晨 03:14:07 YYYY-MM-DD hh:mm:ss 混合日期和时间值，时间戳"]
[null,"TIMESTAMP",null,null,null,"TIMESTAMP WITH TIME ZONE\nTIMESTAMP WITH LOCAL TIME ZONE\nINTERVAL YEAR TO MONTH\nINTERVAL DAY TO SECOND\nTIME WITH TIME ZONE\nTIMESTAMP WITHOUT TIME ZONE"]
[]
[]
[]
[]
["枚举数据类型","ENUM",{"$nulls":4},"枚举类型，只能有一个枚举字符串值 1或2个字节，取决于枚举值的数目 (最大值为65535)"]
[null,"SET",{"$nulls":4},"一个设置，字符串对象可以有零个或 多个SET成员 1、2、3、4或8个字节，取决于集合 成员的数量（最多64个成员）"]
[]
[]
[]
[]
[]
["参照：https://www.runoob.com/mysql/mysql-data-types.html\nhttp://c.biancheng.net/view/2422.html"]

{"sheet":"DB2","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}