# 1115 - Unknown character set: 'utf8mb4' [closed]

Question

# 1115 - Unknown character set: 'utf8mb4' [closed]

Navigation

#1 by (2 votes)

0

When migrating the MAMP database to the server Are you giving me this error? Can you help me?

Error SQL command:

/*!40101 SET NAMES utf8mb4 */;

MySQL Message:

#1115 - Unknown character set: 'utf8mb4'

sql

asked by anonymous 20.12.2016 / 15:06

1 answer

Problem with accentuation when executing python script straight from C # Creating new users through Shell Script

score 2 · Answer 1

According to the manual:

link

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

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

SELECT @@version

One solution, if you can not upgrade the remote server, you would use charset utf8 same. The only restriction is that Unicode characters with code above 65535 would not be stored, but this will probably not be a big deal unless you need support for more remotely used languages or out-of-the-box symbols.