All Products
Search
Document Center

Technical standards

Last Updated: Aug 19, 2021

This topic describes the general technical standards of OceanBase Database.

The following table describes the technical standards of OceanBase Database.

Item

MySQL mode

Oracle mode

Maximum length of a cluster name

128 bytes

128 bytes

Maximum length of a tenant name

64 bytes

64 bytes

Maximum length of a username

64 bytes

64 bytes

Maximum length of a database name

128 bytes

N/A

Maximum length of a table name

64 bytes

128 bytes

Maximum length of a column name

128 bytes

128 bytes

Maximum length of an index name

64 bytes

128 bytes

Maximum length of a view name

64 bytes

128 bytes

Maximum length of an alias

255 bytes

255 bytes

Maximum length of an object name

N/A

128 bytes

Maximum length of a table group name

128 bytes

128 bytes

Maximum length of a CHAR column

255 bytes

2,000 bytes

Maximum length of a VARCHAR column

262,143 bytes

32,767 bytes

Maximum length of a BINARY column

255 bytes

N/A

Maximum length of a VARBINARY column

64,000 bytes

N/A

Maximum length of a row

1.5 million bytes

1.5 million bytes

Maximum number of columns in a table

512

512

Maximum number of indexes for a table

128

128

Maximum number of columns in an index

512

512

Maximum length of an index column

262,143 bytes

262,143 bytes

Maximum length of an index

1.5 million bytes

1.5 million bytes

Maximum number of columns in a primary key

64

64

Maximum length of a primary key column

262,143 bytes

262,143 bytes

Maximum length of a primary key

16,000

16,000