django test database is not created with utf8

Question

I am using utf-8 general case insensitive for for mysql database, but django creates a test db with latin collation

I have set this:

TEST_CHARSET="utf8_general_ci"

TEST_COLLATION="utf8_general_ci"

In the settings file, but to no avail.

What else should i do?

did you validate your settings and then `syncdb` after? – Jordan Oct 15 '12 at 11:38 — Jordan, Oct 15 '12 at 11:38

score 29 · Answer 1 · answered Aug 09 '15 at 11:14

29

TEST_CHARSET and TEST_COLLATION are renamed to CHARSET and COLLATION and moved to TEST dictionary in Django 1.8:

DATABASES = {
    ...
    'TEST': {
        'CHARSET': 'utf8',
        'COLLATION': 'utf8_general_ci',
    }
}

answered Aug 09 '15 at 11:14

dexity

756
7
7

1

Incidentally that is documented here https://docs.djangoproject.com/en/dev/ref/settings/#test – Gordon Wrigley Dec 22 '17 at 14:01

score 12 · Answer 2 · answered May 22 '13 at 20:30

12

in settings add:

DATABASES = {
    'default': {
        ...
        'TEST_CHARSET': "utf8",
        'TEST_COLLATION': "utf8_general_ci",
    }
}

answered May 22 '13 at 20:30

maciejga

121
1
3

score 9 · Answer 3 · answered Oct 28 '17 at 15:27

Please see here: https://docs.djangoproject.com/en/1.11/ref/settings/#std:setting-DATABASE-TEST

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': <db_name>,
        'USER': <user>,
        'PASSWORD': <password>,
        'HOST': <host>,
        'PORT': <port>,
        'TEST': {
            'NAME': <test_db_name>,
            'CHARSET': 'utf8',
            'COLLATION': 'utf8_general_ci',
        },
    },
}

score 1 · Answer 4 · answered Mar 08 '13 at 14:43

1

I had the same problem and spent hours of figuring it out until noticed that

TEST_CHARSET
TEST_COLLATION

should be a part of the DATABASES, not settings.py. It's very easy to mix them up...

https://docs.djangoproject.com/en/dev/ref/settings/#testing

answered Mar 08 '13 at 14:43

Maxim

52,561
27
155
209

score 0 · Answer 5 · answered Apr 05 '20 at 19:51

As others have pointed out, you need something like this to create the database

DATABASES = {
    ...
    'TEST': {
        'CHARSET': 'utf8mb4',
        'COLLATION': 'utf8mb4_unicode_ci',
    }
}

But you also will want to make sure that you have something like this as well, to make sure that your tests communicate with the db with the appropriate charset.

DATABASES = {
    ...
    'OPTIONS': {
        'charset': 'utf8mb4'
     }
}

score -2 · Answer 6 · answered Oct 15 '12 at 14:36

-2

Take a look at the settings file example here: https://docs.djangoproject.com/en/dev/ref/databases/#connecting-to-the-database

answered Oct 15 '12 at 14:36

sampson-chen

45,805
12
84
81

This is subject to link rot. You should expend the answer to add pertinent information. – Sardathrion - against SE abuse Nov 13 '15 at 10:11

django test database is not created with utf8

6 Answers6