kallookoo/Solution-sql-not-utf8-chars.md

Last active July 31, 2025 08:39

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kallookoo/2a493273ef934c50fccb6f2dbca55509.js"></script>
Save kallookoo/2a493273ef934c50fccb6f2dbca55509 to your computer and use it in GitHub Desktop.

Solution sql not utf8 chars

Raw

Possible solution

sudo mariadb-dump --default-character-set=latin1 database > database.sql

Remplace mariadb-dump by mysqldump for MySQL

Edit the database.sql and change the /*!40101 SET NAMES latin1 */; by /*!40101 SET NAMES utf8mb4 */;
Import the database

sudo mariadb --default-character-set=utf8mb4_0900_ai_ci database < database.sql

Remplace mariadb by mysql for MySQL

Note

utf8mb4_0900_ai_ci is the new default.