Django 3.2+: case-sensitive string comparisons within MySQL tables

Django documentation (3.2 to 4.0) states:

In MySQL, a database table’s collation determines whether string comparisons (such as the expression and substring of this function) are case-sensitive. Comparisons are case-insensitive by default.

from 3.2 on, there is mention that it is now possible to define at the level of the CharField the collation to use: https://docs.djangoproject.com/en/3.2/ref/databases/#collation-settings

but I find nowhere what value I should use for db_collation to enable case-sensitive string comparisons for a given CharField:

case_sensitive_collation = ???    
name = models.CharField(max_length=50, db_collation=case_sensitive_collation)

Just found this gist to do the contrary: CreateCollation and db_collation to implement a case-insensitive Charfield with Postgres > 12 https://gist.github.com/hleroy/2f3c6b00f284180da10ed9d20bf9240a

can somebody help me out?

To validate the solution proposed by @rickjames, I'll document an implementation of the answer here:

in settings.py:

if app_version == 'prod':
    DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.mysql',
            'OPTIONS': {
                'read_default_file': '/home/src/my.cnf'
            }
        }
    }
    DB_IS_MYSQL = True
else:
    DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.sqlite3',
            'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
        }
    }
    DB_IS_MYSQL = False

MYSQL_SENSITIVE_COLLATION = 'ascii_bin'  
DB_CASE_SENSITIVE_COLLATION  = {'db_collation': MYSQL_SENSITIVE_COLLATION} if DB_IS_MYSQL else {}
# Use: 
# from django.conf import settings
# pieces = models.CharField(max_length=255, default='empty', unique=True, **settings.DB_CASE_SENSITIVE_COLLATION)

in model.py:

name = models.CharField(max_length=50, **settings.DB_CASE_SENSITIVE_COLLATION)
Back to Top