Django + MySQL - Unknown encoding: utf8mb4

Question

MySQL 5.5.35 Django 1.6.1

In order to support emoticons in the DB, I have configured in my django settings:

'OPTIONS': {'charset': 'utf8mb4'}

On MySQL connection, I get this error: LookupError: unknown encoding: utf8mb4

How should I configure Django/MySQL in order to support utf8mb4?

You may want to verify the MySQL version in use.

Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams

2014-02-02 22:59:03 +00:00
Commented Feb 2, 2014 at 22:59 — Ignacio Vazquez-Abrams
– Ignacio Vazquez-Abrams, Commented Feb 2, 2014 at 22:59

Tim Tisdall · Accepted Answer · 2014-05-21 18:33:45Z

18

https://code.djangoproject.com/ticket/18392#comment:10

As a workaround, you can make python understand 'utf8mb4' as an alias for 'utf8':
import codecs
codecs.register(lambda name: codecs.lookup('utf8') if name == 'utf8mb4' else None)

answered May 21, 2014 at 18:33

Tim Tisdall

10.5k3 gold badges60 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Tim Tisdall Over a year ago

@ChrisSH - I don't remember where I put it... It needs to run once and probably before it makes the DB connection. Maybe in the __init__.py or in settings.py?

Günay Gültekin Over a year ago

this is also worked for sqlalchemy to connect mysql database.

Tim Tisdall Over a year ago

@GünayGültekin - I think the issue is specific to the db adapter used with sqlalchemy and not sqlalchemy itself. Which adapter are you using that this works with?

Tim Tisdall Over a year ago

@GünayGültekin - have you tried passing the charset arg as shown in the docs? It seems like your adapter should support utf8mb4 out-of-the-box (according to the docs).

nanchen · Accepted Answer · 2015-10-26 02:55:51Z

11

If you really need utf8mb4, follow the steps in https://mathiasbynens.be/notes/mysql-utf8mb4, and make sure your python package "MySQL-python" version is >= 1.2.5 !

answered Oct 26, 2015 at 2:55

nanchen

1111 silver badge2 bronze badges

Comments

Meikel · Accepted Answer · 2018-10-29 17:52:18Z

0

Fast and easy way.

connection = mysql.connector.connect(user='username',
                                   password='mypass',
                                    host='localhost',
                                     database='mydb',
                                       use_pure=True,
                                      charset='utf8'
                                      )

answered Oct 29, 2018 at 17:52

Meikel

211 bronze badge

1 Comment

Madhur Bhaiya Over a year ago

Code only answers are not good. An explanation (with proper references) will make this answer upvote worthy :)

addmoss · Accepted Answer · 2021-10-19 06:45:51Z

-1

This worked in my case (MySQL 5.7 + Django 3.1):

Configure Django:

'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {
 'charset': 'utf8mb4' 
}

Configure MySQL database

make sure all db tables are using InnoDB storage engine (this is important; the next step will probably fail if you skip it)
change the Collation for all your tables to utf8mb4_general_ci

edited Oct 19, 2021 at 6:45

answered Mar 31, 2021 at 11:45

addmoss

71210 silver badges14 bronze badges

Collectives™ on Stack Overflow

Django + MySQL - Unknown encoding: utf8mb4

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related