The Ultimate Guide to High Availability with MariaDB

Comments - CREATE DATABASE

6 years ago Zbigniew Szmigiero
Re: CREATE DATABASE

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?

 
6 years ago Zbigniew Szmigiero
Re: CREATE DATABASE

another problematic collation cp1257_general_nopad_ci

 
6 years ago Ian Gilfillan
Re: CREATE DATABASE

cp1257_general_nopad_ci appears to work fine without quotes. Binary is probably related to it being a reserved word.

 
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.