Describe the bug
SET grammar doesn't account for CHARACTER SET and breaks when encountering that combination.

To Reproduce

CREATE TABLE `table_notes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `notes` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
);

set('A', 'B', 'C') works. Set defaults also works.