Convert into lower case while saving in database Django

Question

I am adding few names in my database using the admin panel. How can I convert the the name string to lowercase before saving?

My models.py currently looks this :

from os import name
from django.db import models
from datetime import datetime

# Create your models here.
class Certificate(models.Model):
    name = models.CharField(max_length=50, default="", primary_key=True)
    CertID = models.CharField(max_length=50)
    event = models.CharField(max_length=50, default="")
    year = models.IntegerField(default=datetime.today().year)

def __str__(self):
    return self.CertID

My admin.py looks like this:

from django.contrib import admin
from .models import Certificate


class AdminCertificate(admin.ModelAdmin):
    list_display = ['CertID','name','event','year']


# Register your models here.
admin.site.register(Certificate, AdminCertificate)

does [this](https://stackoverflow.com/questions/36330677/django-model-set-default-charfield-in-lowercase) answer your question? — Sashaank, Sep 24 '20 at 11:00
Does this answer your question? [How do you make a lowercase field in a django model?](https://stackoverflow.com/questions/48574940/how-do-you-make-a-lowercase-field-in-a-django-model) — svorcan, Sep 24 '20 at 11:01

score 0 · Answer 1 · answered Sep 24 '20 at 11:00

0

Perhaps not a direct answer, but most SQL databases support collations which are case insensitive. For example, on MySQL you could create such a table:

CREATE TABLE yourTable (
    c1 VARCHAR(10)
) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci;

Were you insert any text from the above character set, its case would not matter. This means you wouldn't have to do any special handling from your Django code, you could just store regardless of case.

answered Sep 24 '20 at 11:00

Tim Biegeleisen

502,043
27
286
360

This will affect the whole table, not only a single field as requested. – svorcan Sep 24 '20 at 11:02
@stalker92 Good point, but columns can also have their own collations. This answer might be useful to someone so I'll leave it here. – Tim Biegeleisen Sep 24 '20 at 12:06

score 0 · Accepted Answer · answered Sep 24 '20 at 11:07

You can try like this by overriding the get_prep_value() method.

class NameField(models.CharField):
    def __init__(self, *args, **kwargs):
        super(NameField, self).__init__(*args, **kwargs)

    def get_prep_value(self, value):
        return str(value).lower()

class Certificate(models.Model):
    name = NameField(max_length=50, default="", primary_key=True)
    CertID = models.CharField(max_length=50)
    event = models.CharField(max_length=50, default="")
    year = models.IntegerField(default=datetime.today().year)

Convert into lower case while saving in database Django

2 Answers2