Not able to create database with encoding / collation options

[ngoduykhanh]

Hi,

I have just tried with radondb, it worked fine with the normal database creation but not for extra options. See below:

mysql> create database test1;
Query OK, 1 row affected (0.00 sec)

mysql>  create database test1 character set utf8 collate utf8_general_ci;
ERROR 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use, syntax error at position 32 near 'character'`

RadonDB's output log:

2018/05/16 10:09:09.701490 query.go:63:    	 [ERROR] 	query[create database test1 character set utf8 collate utf8_general_ci].parser.error: syntax error at position 32 near 'character'
2018/05/16 10:09:09.701532 server.go:204:    	 [ERROR] 	server.handle.query.from.session[2].error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use, syntax error at position 32 near 'character' (errno 1149) (sqlstate 42000).query[create database test1 character set utf8 collate utf8_general_ci]

This command works fine on normal mysql instance. What can be a problem?

[BohuTANG]

Hi,

Please reference the sql-support doc(DDL) here:
https://github.com/radondb/radon/blob/master/docs/radon_sql_support.md