25 C
Lào Cai
Monday, September 21, 2020

How to Fix ERROR 1115 (42000): Unknown character set: ‘utf8mb4’

- Advertisement -
- Advertisement -

Your version does not support that character set, I believe it was 5.5.3 that introduced it. You should upgrade your mysql to the version you used to export this file.

The error is then quite clear: you set a certain character set in your code, but your mysql version does not support it, and therefore does not know about it.

https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html :

so maybe there is a chance you can just make it utf8, close your eyes and hope, but that would depend on your data, and I’d not recommend it.

Open sql file by text editor find and replace all

utf8mb4 to utf8

Import again.

- Advertisement -
Dung Vuhttps://www.iwmce.com
Share technology knowledge together. Learn experience to develop yourself.

Latest news

How to make a handlebars helper global (in expressjs)

in helpers/handlebars.js: var register = function(Handlebars) { var helpers = { inc: function(value,...
- Advertisement -

How to Fix ERROR 1115 (42000): Unknown character set: ‘utf8mb4’

Your version does not support that character set, I believe it was 5.5.3 that introduced it. You should upgrade your mysql to the version...

Close all tabs, but not the window, in Sublime Text

My way is revert all files after to close all files: View/Show Console and enter command:

Modern Monochrome Home with Calm and Cosy Terrace and Steps

All right. Well, take care yourself. I guess that's what you're best, presence old master? A tremor in the Force. The last...

Related news

How to make a handlebars helper global (in expressjs)

in helpers/handlebars.js: var register = function(Handlebars) { var helpers = { inc: function(value,...

How to Fix ERROR 1115 (42000): Unknown character set: ‘utf8mb4’

Your version does not support that character set, I believe it was 5.5.3 that introduced it. You should upgrade your mysql to the version...

Close all tabs, but not the window, in Sublime Text

My way is revert all files after to close all files: View/Show Console and enter command:

Modern Monochrome Home with Calm and Cosy Terrace and Steps

All right. Well, take care yourself. I guess that's what you're best, presence old master? A tremor in the Force. The last...
- Advertisement -

BÌNH LUẬN

Vui lòng nhập bình luận của bạn
Vui lòng nhập tên của bạn ở đây