|
According to standard mariadb syntax: https://mariadb.com/kb/en/mariadb/create-table/#default-character-setcharset 'default' is optional with charset, however it is required if the table is columnstore. This was reported here: https://mariadb.com/kb/en/mariadb/create-table-charset/
The test below shows this and it working for InnodB:
MariaDB [test]> create table t1(c char(10)) engine=columnstore charset=latin1;
|
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
|
MariaDB [test]> create table t1(c char(10)) engine=columnstore default charset=latin1;
|
Query OK, 0 rows affected (0.47 sec)
|
MariaDB [test]> create table t2(c char(10)) engine=InnoDB charset=latin1;
|
Query OK, 0 rows affected (0.02 sec)
|
|