How to fix mysql error 1097 -Too many strings for column SET?

Question

MySQL

I can not find information on the Internet on the error
Code: 1097 - Error: Too many strings for column 16301 and SET https
://dev.mysql.com/doc/mysql-errors/8.0/en/serv...

field with SET type trying to add many possible values, SQL example:

ALTER TABLE `goods_details_166332`
 CHANGE `16301` `16301` SET('23346','23353','23618','23620','23345','23351','23347','23621','23623','23624','23352','23348','23344','23626','23371','23628','23374','23343','23373','23349','23629','23631','23375','23378','23379','23350','23366','23365','23369','23638','23377','23342','23609','23611','23613','23599','23593','23600','23589','23376','23372','23367','23368','23370','23359','23595','23612','23592','23601','23614','23591','23357','23355','23615','23616','23603','23597','23360','23362','23364','23607','23354','23605','23363','23356','23608','23358','23361','23632','23648','23633','23634','23635','23636','23643','23644','23651','23652','23653','23647','23639','23649','23640','23641','23642','23650','23645') CHARACTER SET utf8 COLLATE utf8_general_ci;

Answer 1

Only 64 values ​​​​are possible in the set field, since in fact it is a bitmask. You have 87 of them in your request. You will have to switch to a subordinate table or JSON field