Comments - CREATE DATABASE
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
What is the supported database name literal?
Please check that some names generate errors:
CREATE DATABASE 3E4n6b3O0E;
I have no idea what is allowed or disallowed. Could you provide better description?
Identifier Names gives details - it will be added into the article.
I have noticed that some collations provides syntax errors.
Fore example:
CREATE DATABASE PkDfzNFNat DEFAULT CHARACTER SET binary COLLATE binary
generates error but
CREATE DATABASE PkDfzNFNat DEFAULT CHARACTER SET binary COLLATE 'binary'
works well. Some collation names have to be quoted. Is it something wrong in the SQL syntax parser?
another problematic collation cp1257_general_nopad_ci
cp1257_general_nopad_ci appears to work fine without quotes. Binary is probably related to it being a reserved word.