Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Unknown character set: 'utf8mb4'

kalvaro's profile image kalvaro posted 7 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, 7 years ago, revision 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
ansgar's profile image ansgar posted 7 years ago Permalink

Yes, think you're right.

Done in r5034.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.