Help Center/ GaussDB/ MySQL Compatibility(Distributed)/ MYSQL-compatible Mode/ Data Types/ Binary Data Types
Updated on 2025-06-30 GMT+08:00
View PDF
Share

Binary Data Types

Table 1 Binary data types

MySQL

GaussDB

Difference

BINARY[(M)]

Not supported

-

VARBINARY(M)

Not supported

-

TINYBLOB

Supported, with differences
  • Value range: In GaussDB, this type is mapped from the BYTEA type. Its length cannot exceed 1 GB. Otherwise, an error is reported. In MySQL, the length of this type cannot exceed 255 bytes. Otherwise, an error is reported in strict mode, and data is truncated and an alarm is generated in loose mode.
  • Input format: Escape characters and double quotation marks ("") are not supported.
  • Output format: For the '\0' character, the query result is displayed as "\000". If the getBytes API of the JDBC driver is used, the result is the '\0' character.
  • Operator: Arithmetic operators (+ - * / %) are not supported. Common logical operators OR, AND, NOT (|| && !) are not supported. Common bitwise operators (~ & | ^) are not supported.

BLOB

Supported, with differences
  • Value range: In GaussDB, this type is mapped from the BYTEA type. Its length cannot exceed 1 GB. Otherwise, an error is reported. In MySQL, the length of this type cannot exceed 65535 bytes. Otherwise, an error is reported in strict mode, and data is truncated and an alarm is generated in loose mode.
  • Input format: Escape characters and double quotation marks ("") are not supported.
  • Output format: For the '\0' character, the query result is displayed as "\000". If the getBytes API of the JDBC driver is used, the result is the '\0' character.
  • Operator: Arithmetic operators (+ - * / %) are not supported. Common logical operators OR, AND, NOT (|| && !) are not supported. Common bitwise operators (~ & | ^) are not supported.

MEDIUMBLOB

Supported, with differences
  • Value range: In GaussDB, this type is mapped from the BYTEA type. Its length cannot exceed 1 GB. Otherwise, an error is reported. In MySQL, the length of this type cannot exceed 16777215 bytes. Otherwise, an error is reported in strict mode, and data is truncated and an alarm is generated in loose mode.
  • Input format: Escape characters and double quotation marks ("") are not supported.
  • Output format: For the '\0' character, the query result is displayed as "\000". If the getBytes API of the JDBC driver is used, the result is the '\0' character.
  • Operator: Arithmetic operators (+ - * / %) are not supported. Common logical operators OR, AND, NOT (|| && !) are not supported. Common bitwise operators (~ & | ^) are not supported.

LONGBLOB

Supported, with differences
  • Value range: In GaussDB, this type is mapped from the BYTEA type. Its length cannot exceed 1 GB. For details, see the centralized and distributed specifications of the BYTEA data type.
  • Input format: Escape characters and double quotation marks ("") are not supported.
  • Output format: For the '\0' character, the query result is displayed as "\000". If the getBytes API of the JDBC driver is used, the result is the '\0' character.
  • Operator: Arithmetic operators (+ - * / %) are not supported. Common logical operators OR, AND, NOT (|| && !) are not supported. Common bitwise operators (~ & | ^) are not supported.

BIT[(M)]

Not supported

-
Parent topic: Data Types