{"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":"50c12887a1603aefaa2bf6659dda21bc5112947d483d426a1375c7820e1e34c5","isBugfix":0.5762,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.7087,"feature":0.0411,"refactor":0.126,"tests_only":0.0941,"docs_only":0.0062,"dependency":0.0239},"confidence":0.4351},"scope":{"score":0.7337,"probabilities":{"0":0.4023,"1":0.4616,"2":0.1361},"confidence":0.0902},"risk":{"score":0.8888,"probabilities":{"0":0.4391,"1":0.2329,"2":0.328},"confidence":0.032},"area":{"choice":"framework","probabilities":{"catalog":0.0104,"checkout":0.0079,"customer":0.0063,"admin":0.0155,"graphql_api":0.006,"framework":0.9089,"frontend":0.0084,"other":0.0366},"confidence":0.8033},"securityRelevant":0.0093,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.0043,"2.4.0-p1":0.0048,"2.4.1":0.0049,"2.4.1-p1":0.0045,"2.4.2":0.0068,"2.4.2-p1":0.0062,"2.4.2-p2":0.0083,"2.4.3":0.0136,"2.4.3-p1":0.0145,"2.4.3-p2":0.0136,"2.4.3-p3":0.0083,"2.4.4":0.0203,"2.4.4-p1":0.0092,"2.4.4-p10":0.0075,"2.4.4-p11":0.0116,"2.4.4-p12":0.0082,"2.4.4-p13":0.0082,"2.4.4-p14":0.0119,"2.4.4-p15":0.0071,"2.4.4-p16":0.0077,"2.4.4-p17":0.0066,"2.4.4-p18":0.0061,"2.4.4-p2":0.0033,"2.4.4-p3":0.0038,"2.4.4-p4":0.0037,"2.4.4-p5":0.0041,"2.4.4-p6":0.0044,"2.4.4-p7":0.0048,"2.4.4-p8":0.0056,"2.4.4-p9":0.0043,"2.4.5":0.0113,"2.4.5-p1":0.0097,"2.4.5-p10":0.0069,"2.4.5-p11":0.0133,"2.4.5-p12":0.0095,"2.4.5-p13":0.0086,"2.4.5-p14":0.0093,"2.4.5-p15":0.0069,"2.4.5-p16":0.0079,"2.4.5-p17":0.0066,"2.4.5-p2":0.0035,"2.4.5-p3":0.0044,"2.4.5-p4":0.0047,"2.4.5-p5":0.0054,"2.4.5-p6":0.0072,"2.4.5-p7":0.006,"2.4.5-p8":0.0054,"2.4.5-p9":0.0044,"2.4.6":0.0324,"2.4.6-p1":0.0176,"2.4.6-p10":0.01,"2.4.6-p11":0.0127,"2.4.6-p12":0.0092,"2.4.6-p13":0.0098,"2.4.6-p14":0.009,"2.4.6-p15":0.0077,"2.4.6-p2":0.0042,"2.4.6-p3":0.0055,"2.4.6-p4":0.0086,"2.4.6-p5":0.0078,"2.4.6-p6":0.0092,"2.4.6-p7":0.0085,"2.4.6-p8":0.0048,"2.4.6-p9":0.0048,"2.4.7":0.0136,"2.4.7-p1":0.0102,"2.4.7-p10":0.0092,"2.4.7-p2":0.0062,"2.4.7-p3":0.0104,"2.4.7-p4":0.0135,"2.4.7-p5":0.012,"2.4.7-p6":0.0145,"2.4.7-p7":0.0124,"2.4.7-p8":0.0097,"2.4.7-p9":0.0055,"2.4.8":0.017,"2.4.8-p1":0.0127,"2.4.8-p2":0.0124,"2.4.8-p3":0.0123,"2.4.8-p4":0.0148,"2.4.8-p5":0.0108,"2.4.9":0.0135,"unspecified":0.2683},"confidence":0.069},"backportWorthy":{"score":1.2142,"probabilities":{"0":0.2149,"1":0.3559,"2":0.4292},"confidence":0.0356}},"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"}