I cannot set more than one value to a "SET" field.

[Fabio286]

Discussed in #620

^{Originally posted by cbocaz July 15, 2023}
In a table with a column of type "SET", I am unable to set more than one value from the assigned values in the table's DDL.

Example:
CREATE TABLE test ( id int unsigned NOT NULL AUTO_INCREMENT, name varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, type set('valA','valB','valC') NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

If I try to insert a record, both in the grid and the "Insert rows" button functionality, it is impossible to set, for example, the value "valA,valC".

Can anyone help?

[Fabio286]

Closed with 7c820b1