Bug 39833

Summary: mysqldump SET character_set_client = utf8 vs utf8mb4
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Architecture, internals, and plumbingAssignee: Jonathan Druart <jonathan.druart>
Status: Pushed to main --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: dcook
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
25.05.00
Circulation function:
Attachments: Bug 39833: Adjust character_set_client in kohastructure.sql

Description Jonathan Druart 2025-05-05 12:13:06 UTC
We have 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

but kohastructure.sql has
/*!40101 SET character_set_client = utf8 */;

However it seems that now koha-dump uses:
/*!40101 SET character_set_client = utf8mb4 */;
Comment 1 Jonathan Druart 2025-05-05 12:21:14 UTC
Created attachment 181914 [details] [review]
Bug 39833: Adjust character_set_client in kohastructure.sql

koha-dump now generates the dump with utf8mb4
Comment 2 Jonathan Druart 2025-05-05 12:24:14 UTC
Pushed to main for 25.05.