I would like to use utf8mb4 charset, but I'm not sure magento support it or not. I worry about index size. Anyone using utf8mb4 in production now?
Mine crashed during bin/magento setup:upgrade with the following error
SQLSTATE[HY000]: General error: 1283 Column 'content' cannot be part of FULLTEXT index, query was: ALTER TABLE `cms_block` MODIFY COLUMN `content` mediumtext NULL COMMENT "Block Content", DEFAULT CHARSET='utf8', DEFAULT COLLATE='utf8_general_ci'
So in my opinion magento 2.4.5 is not compatible with utf8mb4