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.
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.