{"data":{"id":"magento2-35174","source":"github-pr","sourceRef":"magento/magento2#35174","title":"Set default collation to utf8mb4","pr":{"number":35174,"url":"https://github.com/magento/magento2/pull/35174","author":"sippsolutions","mergedAt":"2024-10-31T11:59:03Z","mergeCommit":"c10fc657c347b78695593f5ba0162d79f770980a","headCommit":"1389b85828810dec3fa92bff55df18b816e38191","baseRef":"2.4-develop","diffSha256":"c27f284629d59355cdd933948f1dc2ee2d3a6975b86deb3f2b4dfca012824a9c"},"issues":[{"number":38085,"url":"https://github.com/magento/magento2/issues/38085","title":"[Issue] Set default collation to utf8mb4","labels":["Area: Framework","Component: Setup","Issue: Confirmed","Priority: P3","Progress: done","Reported on 2.4.x","Reproduced on 2.4.x"],"kind":"pr-derived"}],"fixedIn":"2.4.8","containingTags":["2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5","2.4.9"],"reportedOn":null,"codeMatch":{"2.4.6":"clean","2.4.6-p1":"clean","2.4.6-p2":"clean","2.4.6-p3":"clean","2.4.6-p4":"clean","2.4.6-p5":"clean","2.4.6-p6":"clean","2.4.6-p7":"clean","2.4.6-p8":"clean","2.4.6-p9":"clean","2.4.6-p10":"clean","2.4.6-p11":"conflict","2.4.6-p12":"conflict","2.4.6-p13":"conflict","2.4.6-p14":"conflict","2.4.6-p15":"conflict","2.4.7":"clean","2.4.7-p1":"clean","2.4.7-p2":"clean","2.4.7-p3":"clean","2.4.7-p4":"clean","2.4.7-p5":"clean","2.4.7-p6":"conflict","2.4.7-p7":"conflict","2.4.7-p8":"conflict","2.4.7-p9":"conflict","2.4.7-p10":"conflict","2.4.8":"conflict","2.4.8-p1":"conflict","2.4.8-p2":"conflict","2.4.8-p3":"conflict","2.4.8-p4":"conflict","2.4.8-p5":"conflict","2.4.9":"conflict"},"affectedVersions":["2.4.6","2.4.6-p1","2.4.6-p2","2.4.6-p3","2.4.6-p4","2.4.6-p5","2.4.6-p6","2.4.6-p7","2.4.6-p8","2.4.6-p9","2.4.6-p10","2.4.7","2.4.7-p1","2.4.7-p2","2.4.7-p3","2.4.7-p4","2.4.7-p5"],"components":["magento/framework"],"files":[{"path":"lib/internal/Magento/Framework/Setup/Declaration/Schema/Dto/Factories/Table.php","change":"modified","package":"magento/framework"}],"stripped":{"tests":["dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/constraint_modification.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/constraint_modification.mysql829.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/rollback.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/rollback.mysql829.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/table_removal.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/table_removal.mysql829.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/table_rename.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/declarative_installer/table_rename.mysql829.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/dry_run_log.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/fixture/dry_run_log.mysql829.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/revisions/base_update/InstallSchema.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule1/revisions/old_diff/InstallSchema.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule2/fixture/shards.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule2/fixture/shards.mysql829.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule9/fixture/declarative_installer/disabling_tables.mariadb10611.php","dev/tests/setup-integration/_files/Magento/TestSetupDeclarationModule9/fixture/declarative_installer/disabling_tables.mysql829.php"],"docs":[],"outsideCode":[]},"linesChanged":8,"mergeBatched":false,"excluded":null,"sections":{"description":"MySQL 8 interprets utf8 as utf8mb3, which is deprecated:\nhttps://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24.html\nhttps://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html\nWe should therefor ensure utf8mb4 is used.","stepsToReproduce":null,"expectedResult":null,"actualResult":null,"source":"pr"},"signatures":[],"labels":{"area":["Framework"],"component":["Setup"],"priority":"P3","severity":null,"reportedOn":["2.4.x"]},"categories":[],"triage":{"model":"@cf/cloudflare/clef","requestHash":"a3fd2c009e1e02484302ad1a4872626d14b00a20df9077ad100deab685788797","isBugfix":0.5302,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.6417,"feature":0.0324,"refactor":0.0917,"tests_only":0.0651,"docs_only":0.005,"dependency":0.015,"cleanup":0.1491},"confidence":0.356},"scope":{"score":0.7606,"probabilities":{"0":0.3677,"1":0.504,"2":0.1283},"confidence":0.1085},"risk":{"score":0.8396,"probabilities":{"0":0.4624,"1":0.2356,"2":0.302},"confidence":0.0408},"area":{"choice":"framework","probabilities":{"catalog":0.0118,"checkout":0.0086,"customer":0.0074,"admin":0.0185,"graphql_api":0.0071,"framework":0.8903,"frontend":0.0099,"other":0.0464},"confidence":0.7664},"securityRelevant":0.0096,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.0043,"2.4.0-p1":0.0046,"2.4.1":0.005,"2.4.1-p1":0.004,"2.4.2":0.0074,"2.4.2-p1":0.0068,"2.4.2-p2":0.009,"2.4.3":0.015,"2.4.3-p1":0.0155,"2.4.3-p2":0.0145,"2.4.3-p3":0.0082,"2.4.4":0.0204,"2.4.4-p1":0.0108,"2.4.4-p10":0.0076,"2.4.4-p11":0.0117,"2.4.4-p12":0.0087,"2.4.4-p13":0.0081,"2.4.4-p14":0.0097,"2.4.4-p15":0.0075,"2.4.4-p16":0.008,"2.4.4-p17":0.0064,"2.4.4-p18":0.0058,"2.4.4-p2":0.0031,"2.4.4-p3":0.0034,"2.4.4-p4":0.0034,"2.4.4-p5":0.0042,"2.4.4-p6":0.0049,"2.4.4-p7":0.0042,"2.4.4-p8":0.006,"2.4.4-p9":0.0047,"2.4.5":0.0129,"2.4.5-p1":0.0115,"2.4.5-p10":0.0076,"2.4.5-p11":0.0112,"2.4.5-p12":0.0099,"2.4.5-p13":0.008,"2.4.5-p14":0.0099,"2.4.5-p15":0.0071,"2.4.5-p16":0.0087,"2.4.5-p17":0.0066,"2.4.5-p2":0.0042,"2.4.5-p3":0.0048,"2.4.5-p4":0.0061,"2.4.5-p5":0.0053,"2.4.5-p6":0.0079,"2.4.5-p7":0.0068,"2.4.5-p8":0.0066,"2.4.5-p9":0.0053,"2.4.6":0.0335,"2.4.6-p1":0.0199,"2.4.6-p10":0.0101,"2.4.6-p11":0.0121,"2.4.6-p12":0.01,"2.4.6-p13":0.0096,"2.4.6-p14":0.0095,"2.4.6-p15":0.0072,"2.4.6-p2":0.0043,"2.4.6-p3":0.0065,"2.4.6-p4":0.0086,"2.4.6-p5":0.0088,"2.4.6-p6":0.0088,"2.4.6-p7":0.0074,"2.4.6-p8":0.0053,"2.4.6-p9":0.0057,"2.4.7":0.0148,"2.4.7-p1":0.0102,"2.4.7-p10":0.0095,"2.4.7-p2":0.0067,"2.4.7-p3":0.0099,"2.4.7-p4":0.015,"2.4.7-p5":0.011,"2.4.7-p6":0.0149,"2.4.7-p7":0.0154,"2.4.7-p8":0.0109,"2.4.7-p9":0.0059,"2.4.8":0.0191,"2.4.8-p1":0.0141,"2.4.8-p2":0.0144,"2.4.8-p3":0.013,"2.4.8-p4":0.0158,"2.4.8-p5":0.011,"2.4.9":0.0134,"unspecified":0.2344},"confidence":0.0525},"backportWorthy":{"score":1.1272,"probabilities":{"0":0.2538,"1":0.3652,"2":0.381},"confidence":0.0144}},"curated":{"title":"Sets utf8mb4 as default table charset for the 10.6 and mysql_8_29 keys","description":"MySQL 8 interprets utf8 as utf8mb3, which is deprecated, and the Setup Declaration Schema Factories Table class uses utf8mb3 as default charset and collation for the 10.6 and mysql_8_29 keys. Both keys now use utf8mb4 and utf8mb4_general_ci; the 10.4 and default keys stay utf8.","categories":[],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":null},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-35174 details"}