The following table describes the maximum length for each type of identifier.
|Identifier Type||Maximum Length (characters)|
|Log File Group||64|
|Alias||256 (see exception following table)|
|Compound Statement Label||16|
Aliases for column names in
VIEW statements are checked against the maximum column
length of 64 characters (not the maximum alias length of 256
Identifiers are stored using Unicode (UTF-8). This applies to
identifiers in table definitions that are stored in
.frm files and to identifiers stored in the
grant tables in the
mysql database. The sizes
of the identifier string columns in the grant tables are
measured in characters. You can use multibyte characters without
reducing the number of characters permitted for values stored in
NDB Cluster imposes a maximum length of 63 characters for names of databases and tables. See Section 126.96.36.199, “Limits Associated with Database Objects in NDB Cluster”.
Values such as user name and host names in MySQL account names are strings rather than identifiers. For information about the maximum length of such values as stored in grant tables, see Grant Table Scope Column Properties.