support full spec for character set clauses

columnstore does not support column level character set specification and the collation clause. For example the following fails:
CREATE TABLE table1 ( name char(3) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '') ENGINE=Columnstore

A workaround is to specify at the table level and drop the collate option:
CREATE TABLE table1 ( name char(3) NOT NULL DEFAULT '')default CHARACTER SET latin1 engine=columnstore;

Originally reported here: https://mariadb.com/kb/en/mariadb/character-set-problem-in-columnstore