<\/p>\n\n\n\n
\n\u6570\u636e\u6765\u6e90\uff1a\u6e90\u7801\u8def\u5f84
\/Users\/yuan\/Documents\/code\/oceanbase-4.2.5_CE_BP2_HF1<\/code> \u6838\u5fc3\u5b9a\u4e49\u6587\u4ef6\uff1a<\/p>\n\n\n\n\n
deps\/oblib\/src\/common\/object\/ob_obj_type.h<\/code> \u2014 ObObjType \u679a\u4e3e\u5b9a\u4e49<\/li>\n\n\n\ndeps\/oblib\/src\/rpc\/obmysql\/ob_mysql_global.h<\/code> \u2014 MySQL \u534f\u8bae\u5b57\u6bb5\u7c7b\u578b<\/li>\n\n\n\ndeps\/oblib\/src\/common\/object\/ob_obj_type.cpp<\/code> \u2014 \u53d6\u503c\u8303\u56f4\u6570\u7ec4<\/li>\n\n\n\ndeps\/oblib\/src\/lib\/ob_define.h<\/code> \u2014 \u5404\u7c7b\u578b\u6700\u5927\u957f\u5ea6\u5e38\u91cf<\/li>\n\n\n\nsrc\/observer\/table_load\/backup\/v_3_x\/encoding\/ob_encoding_util.h<\/code> \u2014 \u5b58\u50a8\u5927\u5c0f\u6620\u5c04<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n
\n\n\n\n\u4e00\u3001\u6574\u6570\u7c7b\u578b (Integer Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b (ObObjType)<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u53d6\u503c\u8303\u56f4 (\u6709\u7b26\u53f7)<\/th> \u53d6\u503c\u8303\u56f4 (\u65e0\u7b26\u53f7)<\/th><\/tr> TINYINT<\/td> TINYINT<\/code><\/td>ObTinyIntType (1)<\/td> 1 \u5b57\u8282<\/td> -2\u2077 ~ 2\u2077-1<\/td> 0 ~ 2\u2078-1<\/td><\/tr> SMALLINT<\/td> SMALLINT<\/code><\/td>ObSmallIntType (2)<\/td> 2 \u5b57\u8282<\/td> -2\u00b9\u2075 ~ 2\u00b9\u2075-1<\/td> 0 ~ 2\u00b9\u2076-1<\/td><\/tr> MEDIUMINT<\/td> MEDIUMINT<\/code><\/td>ObMediumIntType (3)<\/td> 3 \u5b57\u8282<\/td> -2\u00b2\u00b3 ~ 2\u00b2\u00b3-1<\/td> 0 ~ 2\u00b2\u2074-1<\/td><\/tr> INT<\/td> INT<\/code> \/INTEGER<\/code><\/td>ObInt32Type (4)<\/td> 4 \u5b57\u8282<\/td> -2\u00b3\u00b9 ~ 2\u00b3\u00b9-1<\/td> 0 ~ 2\u00b3\u00b2-1<\/td><\/tr> BIGINT<\/td> BIGINT<\/code><\/td>ObIntType (5)<\/td> 8 \u5b57\u8282<\/td> -2\u2076\u00b3 ~ 2\u2076\u00b3-1<\/td> 0 ~ 2\u2076\u2074-1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u6ce8\u91ca\uff1a
ObTinyIntType<\/code> \u5373 MySQL BOOLEAN \u7c7b\u578b\u3002\u663e\u793a\u5bbd\u5ea6\u4e0a\u9650OB_MAX_INTEGER_DISPLAY_WIDTH = 255<\/code>\u3002<\/p>\n<\/blockquote>\n\n\n\n\u4e8c\u3001\u6d6e\u70b9\u7c7b\u578b (Floating-Point Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u53d6\u503c\u8303\u56f4<\/th><\/tr> FLOAT<\/td> FLOAT[(M,D)]<\/code><\/td>ObFloatType (11)<\/td> 4 \u5b57\u8282<\/td> \u00b12\u207b\u00b9\u00b2\u2076 ~ \u00b12\u00b9\u00b2\u2078\uff08IEEE 754 \u5355\u7cbe\u5ea6\uff09<\/td><\/tr> DOUBLE<\/td> DOUBLE[(M,D)]<\/code><\/td>ObDoubleType (12)<\/td> 8 \u5b57\u8282<\/td> \u00b12\u207b\u00b9\u2070\u00b2\u00b2 ~ \u00b12\u00b9\u2070\u00b2\u2074\uff08IEEE 754 \u53cc\u7cbe\u5ea6\uff09<\/td><\/tr> FLOAT UNSIGNED<\/td> FLOAT UNSIGNED<\/code><\/td>ObUFloatType (13)<\/td> 4 \u5b57\u8282<\/td> \u540c FLOAT\uff0c\u4ec5\u975e\u8d1f<\/td><\/tr> DOUBLE UNSIGNED<\/td> DOUBLE UNSIGNED<\/code><\/td>ObUDoubleType (14)<\/td> 8 \u5b57\u8282<\/td> \u540c DOUBLE\uff0c\u4ec5\u975e\u8d1f<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u5e38\u91cf\uff1a
OB_MAX_FLOAT_PRECISION = 24<\/code>\uff0cOB_MAX_DOUBLE_FLOAT_PRECISION = 53<\/code>\uff0cOB_MAX_DOUBLE_FLOAT_SCALE = 30<\/code><\/p>\n<\/blockquote>\n\n\n\n\u4e09\u3001\u5b9a\u70b9\u6570\u7c7b\u578b (Fixed-Point Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u8bf4\u660e<\/th><\/tr> DECIMAL<\/td> DECIMAL[(M,D)]<\/code> \/NUMERIC[(M,D)]<\/code><\/td>ObNumberType (15)<\/td> \u53d8\u957f<\/td> M \u6700\u5927 65 \u4f4d\uff0cD \u6700\u5927 30 \u4f4d<\/td><\/tr> DECIMAL UNSIGNED<\/td> DECIMAL UNSIGNED<\/code><\/td>ObUNumberType (16)<\/td> \u53d8\u957f<\/td> \u540c DECIMAL\uff0c\u4ec5\u975e\u8d1f<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u5e38\u91cf\uff1a
OB_MAX_DECIMAL_PRECISION = 65<\/code>\uff0cOB_MAX_DECIMAL_SCALE = 30<\/code>\uff0cOB_MIN_DECIMAL_PRECISION = 1<\/code><\/p>\n<\/blockquote>\n\n\n\n\u56db\u3001\u65e5\u671f\u65f6\u95f4\u7c7b\u578b (Date and Time Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u53d6\u503c\u8303\u56f4<\/th><\/tr> DATE<\/td> DATE<\/code><\/td>ObDateType (19) \/ ObMySQLDateType (52)<\/td> 3 \u5b57\u8282<\/td> ‘1000-01-01’ ~ ‘9999-12-31’<\/td><\/tr> DATETIME<\/td> DATETIME[(fsp)]<\/code><\/td>ObDateTimeType (17) \/ ObMySQLDateTimeType (53)<\/td> 5~8 \u5b57\u8282<\/td> ‘1000-01-01 00:00:00’ ~ ‘9999-12-31 23:59:59.999999’<\/td><\/tr> TIMESTAMP<\/td> TIMESTAMP[(fsp)]<\/code><\/td>ObTimestampType (18)<\/td> 4~7 \u5b57\u8282<\/td> ‘1970-01-01 00:00:01’ UTC ~ ‘2038-01-19 03:14:07’ UTC<\/td><\/tr> TIME<\/td> TIME[(fsp)]<\/code><\/td>ObTimeType (20)<\/td> 3~6 \u5b57\u8282<\/td> ‘-838:59:59’ ~ ‘838:59:59’<\/td><\/tr> YEAR<\/td> YEAR<\/code> \/YEAR(4)<\/code><\/td>ObYearType (21)<\/td> 1 \u5b57\u8282<\/td> 1901 ~ 2155<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\n
- fsp (fractional seconds precision)\uff1a0~6 \u4f4d\u5fae\u79d2\u7cbe\u5ea6\uff0cfsp \u8d8a\u5927\u5b58\u50a8\u8d8a\u5927<\/li>\n\n\n\n
- \u6e90\u7801\u5e38\u91cf\uff1a
OB_MAX_DATETIME_PRECISION = 6<\/code>\uff0cOB_MAX_DATE_PRECISION = 0<\/code><\/li>\n\n\n\nObMySQLDateType<\/code> \u548cObMySQLDateTimeType<\/code> \u662f OceanBase 4.x \u65b0\u589e\u7684 MySQL \u517c\u5bb9\u5185\u90e8\u7c7b\u578b\uff0c\u4e0e Oracle \u6a21\u5f0f\u7684 DATE\/DATETIME \u4f7f\u7528\u4e0d\u540c\u7684\u7f16\u7801\u65b9\u5f0f<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n\u4e94\u3001\u5b57\u7b26\u4e32\u7c7b\u578b (String Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u6700\u5927\u957f\u5ea6<\/th> \u8bf4\u660e<\/th><\/tr> CHAR<\/td> CHAR(M)<\/code><\/td>ObCharType (23)<\/td> 256 \u5b57\u7b26<\/td> \u5b9a\u957f\u5b57\u7b26\u4e32\uff0cM: 0~256<\/td><\/tr> VARCHAR<\/td> VARCHAR(M)<\/code><\/td>ObVarcharType (22)<\/td> 2\u00b2\u2070 \u5b57\u8282 (1MB)<\/td> \u53d8\u957f\u5b57\u7b26\u4e32<\/td><\/tr> BINARY<\/td> BINARY(M)<\/code><\/td>ObCharType (binary)<\/td> 255 \u5b57\u8282<\/td> \u5b9a\u957f\u4e8c\u8fdb\u5236<\/td><\/tr> VARBINARY<\/td> VARBINARY(M)<\/code><\/td>ObVarcharType (binary)<\/td> 2\u00b9\u2076 \u5b57\u8282 (64KB)<\/td> \u53d8\u957f\u4e8c\u8fdb\u5236<\/td><\/tr> HEX STRING<\/td> X'hex'<\/code> \/0xhex<\/code><\/td>ObHexStringType (24)<\/td> \u2014<\/td> \u5341\u516d\u8fdb\u5236\u5b57\u9762\u91cf<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u5e38\u91cf\uff1a<\/p>\n\n\n\n
\n
OB_MAX_CHAR_LENGTH = 256<\/code><\/li>\n\n\n\nOB_MAX_MYSQL_VARCHAR_LENGTH = 65535<\/code>\uff082\u00b9\u2076-1\uff0c\u517c\u5bb9 MySQL\uff09<\/li>\n\n\n\nOB_MAX_VARCHAR_LENGTH = 1048576<\/code>\uff082\u00b2\u2070\uff0cOceanBase \u6269\u5c55\u4e3a 1MB\uff09<\/li>\n\n\n\nOB_MAX_BINARY_LENGTH = 255<\/code><\/li>\n\n\n\nOB_MAX_VARBINARY_LENGTH = 65536<\/code>\uff082\u00b9\u2076\uff09<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n\u516d\u3001\u5927\u6587\u672c \/ LOB \u7c7b\u578b (Text and Blob Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u6700\u5927\u957f\u5ea6<\/th> \u8bf4\u660e<\/th><\/tr> TINYTEXT<\/td> TINYTEXT<\/code><\/td>ObTinyTextType (27)<\/td> 2\u2078 \u5b57\u8282<\/td> \u77ed\u6587\u672c<\/td><\/tr> TEXT<\/td> TEXT<\/code><\/td>ObTextType (28)<\/td> 2\u00b9\u2076 \u5b57\u8282 (64KB)<\/td> \u4e2d\u7b49\u6587\u672c<\/td><\/tr> MEDIUMTEXT<\/td> MEDIUMTEXT<\/code><\/td>ObMediumTextType (29)<\/td> 2\u00b2\u2074 \u5b57\u8282 (16MB)<\/td> \u957f\u6587\u672c<\/td><\/tr> LONGTEXT<\/td> LONGTEXT<\/code><\/td>ObLongTextType (30)<\/td> 2\u00b2\u2079-1 \u5b57\u8282 (~512MB)<\/td> \u8d85\u957f\u6587\u672c<\/td><\/tr> TINYBLOB<\/td> TINYBLOB<\/code><\/td>ObTinyTextType (binary)<\/td> 2\u2078 \u5b57\u8282<\/td> \u77ed\u4e8c\u8fdb\u5236<\/td><\/tr> BLOB<\/td> BLOB<\/code><\/td>ObTextType (binary)<\/td> 2\u00b9\u2076 \u5b57\u8282 (64KB)<\/td> \u4e2d\u7b49\u4e8c\u8fdb\u5236<\/td><\/tr> MEDIUMBLOB<\/td> MEDIUMBLOB<\/code><\/td>ObMediumTextType (binary)<\/td> 2\u00b2\u2074 \u5b57\u8282 (16MB)<\/td> \u957f\u4e8c\u8fdb\u5236<\/td><\/tr> LONGBLOB<\/td> LONGBLOB<\/code><\/td>ObLongTextType (binary)<\/td> 2\u00b2\u2079-1 \u5b57\u8282 (~512MB)<\/td> \u8d85\u957f\u4e8c\u8fdb\u5236<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u5e38\u91cf\uff1a<\/p>\n\n\n\n
\n
OB_MAX_TINYTEXT_LENGTH = 256<\/code> (2\u2078)<\/li>\n\n\n\nOB_MAX_TEXT_LENGTH = 65536<\/code> (2\u00b9\u2076)<\/li>\n\n\n\nOB_MAX_MEDIUMTEXT_LENGTH = 16777216<\/code> (2\u00b2\u2074)<\/li>\n\n\n\nOB_MAX_LONGTEXT_LENGTH = 536870911<\/code>\uff082\u00b2\u2079-1\uff0c\u56e0\u4e3a datum.len_ \u53ea\u6709 29 bit\uff09<\/li>\n\n\n\n- \u6ce8\u610f\uff1aOceanBase \u7684 LONGTEXT \u6700\u5927\u957f\u5ea6\u4e3a ~512MB\uff0c\u800c MySQL \u539f\u751f\u4e3a 4GB<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n
\u4e03\u3001\u4f4d\u7c7b\u578b (Bit Type)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u53d6\u503c\u8303\u56f4<\/th><\/tr> BIT<\/td> BIT(M)<\/code><\/td>ObBitType (31)<\/td> 1~8 \u5b57\u8282<\/td> M=1~64 \u4f4d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u5e38\u91cf\uff1a
OB_MAX_BIT_LENGTH = 64<\/code><\/p>\n<\/blockquote>\n\n\n\n\u516b\u3001\u679a\u4e3e\u548c\u96c6\u5408\u7c7b\u578b (Enum and Set Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u8bf4\u660e<\/th><\/tr> ENUM<\/td> ENUM('val1','val2',...)<\/code><\/td>ObEnumType (32)<\/td> 1~2 \u5b57\u8282<\/td> \u5355\u9009\u679a\u4e3e<\/td><\/tr> SET<\/td> SET('val1','val2',...)<\/code><\/td>ObSetType (33)<\/td> 1~8 \u5b57\u8282<\/td> \u591a\u9009\u96c6\u5408<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u5e38\u91cf\uff1a<\/p>\n\n\n\n
\n
OB_MAX_ENUM_ELEMENT_NUM = 65535<\/code>\uff08\u679a\u4e3e\u503c\u6700\u5927\u6570\u91cf\uff09<\/li>\n\n\n\nOB_MAX_SET_ELEMENT_NUM = 64<\/code>\uff08\u96c6\u5408\u503c\u6700\u5927\u6570\u91cf\uff09<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n\u4e5d\u3001JSON \u7c7b\u578b<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u5b58\u50a8\u5927\u5c0f<\/th> \u8bf4\u660e<\/th><\/tr> JSON<\/td> JSON<\/code><\/td>ObJsonType (47)<\/td> \u53d8\u957f (\u6700\u5927 ~512MB)<\/td> JSON \u6587\u6863<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \nJSON \u7c7b\u578b\u4e0e LONGTEXT \u5171\u4eab LOB \u5b58\u50a8<\/p>\n<\/blockquote>\n\n\n\n
\u5341\u3001\u7a7a\u95f4\u7c7b\u578b (Geometry Types)<\/h2>\n\n\n\n
\u6570\u636e\u7c7b\u578b<\/th> SQL \u58f0\u660e<\/th> \u5185\u90e8\u7c7b\u578b<\/th> \u8bf4\u660e<\/th><\/tr> GEOMETRY<\/td> GEOMETRY<\/code><\/td>ObGeometryType (48)<\/td> \u7a7a\u95f4\u51e0\u4f55\u6570\u636e\uff08\u7236\u7c7b\u578b\uff09<\/td><\/tr> POINT<\/td> POINT<\/code><\/td>ObGeometryType (sub:1)<\/td> \u70b9<\/td><\/tr> LINESTRING<\/td> LINESTRING<\/code><\/td>ObGeometryType (sub:2)<\/td> \u7ebf<\/td><\/tr> POLYGON<\/td> POLYGON<\/code><\/td>ObGeometryType (sub:3)<\/td> \u591a\u8fb9\u5f62<\/td><\/tr> MULTIPOINT<\/td> MULTIPOINT<\/code><\/td>ObGeometryType (sub:4)<\/td> \u591a\u70b9<\/td><\/tr> MULTILINESTRING<\/td> MULTILINESTRING<\/code><\/td>ObGeometryType (sub:5)<\/td> \u591a\u7ebf<\/td><\/tr> MULTIPOLYGON<\/td> MULTIPOLYGON<\/code><\/td>ObGeometryType (sub:6)<\/td> \u591a\u591a\u8fb9\u5f62<\/td><\/tr> GEOMETRYCOLLECTION<\/td> GEOMETRYCOLLECTION<\/code><\/td>ObGeometryType (sub:7)<\/td> \u51e0\u4f55\u96c6\u5408<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n \n\u6e90\u7801\u679a\u4e3e
ObGeoType<\/code> \u5b9a\u4e49\u4e86\u6240\u6709\u5b50\u7c7b\u578b<\/p>\n<\/blockquote>\n\n\n\n\u5341\u4e00\u3001\u7279\u6b8a \/ \u5185\u90e8\u7c7b\u578b<\/h2>\n\n\n\n