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 stable --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: dcook, fridolin.somers
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,24.11.10
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.
Comment 3 Fridolin Somers 2025-09-29 09:00:57 UTC
Pushed to 24.11.x for 24.11.10