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 |