OceanBase Database supports the CHAR, VARCHAR, BINARY, and VARBINARY string types.
The following table describes the supported string types and their related information in the current version of OceanBase Database.
Type |
Length Type |
Length Limit |
Character Set |
|---|---|---|---|
CHAR |
Fixed-length | 256 characters | UTF8MB4 |
VARCHAR |
Variable-length | 262,144 characters | UTF8MB4 |
BINARY |
Fixed-length | 256 bytes | BINARY |
VARBINARY |
Variable-length | 1,048,576 bytes | BINARY |
For the CHAR type, the length is measured in characters. For the VARCHAR, BINARY, and VARBINARY types, the length is measured in bytes.