#1115 - Unknown Character Sep: 'utf8mb4'

Asked

Viewed 1,147 times

0

When migrating the MAMP database to the server Are you making this mistake? Can you help me?

Error SQL command:

/*!40101 SET NAMES utf8mb4 */;

Mysql message:

#1115 - Unknown character set: 'utf8mb4'

sql

  • Mysql server version is the same?

  • I don’t know how I can verify?

  • i am on MAC to develop the site.

  • and now I was going to migrate to my accommodation.

  • Makes a select @@version on both servers.

  • I’m sorry, but I’m not where I do it?

  • In the accommodation the version is this

  • Apache Mysql client version: 5.1.73 PHP Extension: mysql

  • and in the Mamp is 5.6.33

  • 2

    It looks like you used a charset that is not supported by an older version(5.1.x).

  • select @@version vc runs on phpmyadmin or Workbench to discover the Mysql version (cause of the problem).

  • Yes in phpmyadmin

Show 7 more comments

1 answer

3

According to the manual:

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

The charset utf8mb4 was introduced in version 5.5.3. Thus, the remote version really cannot accept this dump if it is smaller than this.

As said the @rray in the comments, you can check the version with the query next:

SELECT @@version

A solution, if you cannot update the remote server, would be to use the charset utf8 same. The only restriction is that Unicode characters with code above 65535 would not be stored, but this probably won’t be a big problem unless you need support for more remotely used languages or symbols too out of the ordinary.

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.