Unknown character set: 'utf8mb4'

959 posts
kalvaro's profile image kalvaro posted 8 years ago in Import/Export Permalink

utf8mb4 wasn't available until MySQL/5.5.3 but HeidiSQL generates this on SQL dumps:

/*!40101 SET NAMES utf8mb4 */;

... which leads to:

/* SQL Error (1115): Unknown character set: 'utf8mb4' */

... on older servers. I guess it should be:

/*!50503 SET NAMES utf8mb4 */;

... or maybe:

/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;

... for some kind of backwards compatibility.

In my case, source database was using utf8_spanish_ci so I don't need really full UTF-8.

P.S. Love markdown support in forum!

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5034
In SQL dumps, make "SET NAMES utf8mb4" a version conditional statement for the minimum MySQL version supporting that charset. See http://www.heidisql.com/forum.php?t=20188
10136 posts
ansgar's profile image ansgar posted 8 years ago Permalink

Yes, think you're right.

Done in r5034.

Please login to leave a reply, or register at first.