Image not saving in database(mysql) and displaying null as blob in django

Question

I am saving 4 images from the user (maybe it will be null). I do not want to save the images in a directory or folder,I need to save the images in db(mysql). The 'form.save' is working and after looking in db the blob is present but there is no data in it.Not only that the null is displaying as blob!

forms.py

  class ClientCreateForm(ModelForm):
    photo = forms.ImageField(required=False)
    signature = forms.ImageField(required=False)
    poi_image = forms.ImageField(required=False)
    poa_image = forms.ImageField(required=False)

model.py

class Client(models.Model):
       
    photo = models.ImageField(db_column='PHOTO', blank=True, null=True)  
    signature = models.ImageField(db_column='SIGNATURE', blank=True, null=True)  
    poi_image = models.ImageField(db_column='POI_IMAGE', blank=True, null=True)  
    poa_image = models.ImageField(db_column='POA_IMAGE', blank=True, null=True)

views.py

def client_create_view(request):
  if request.method == 'POST':
     form = ClientCreateForm(request.POST)
        if form.is_valid():
          form.save()
        else:
          pass

Mohamed ElKalioby · Accepted Answer · 2021-06-09 05:11:55Z

1

According to Django documentation, this is not how ImageField and FileField works, they save in MEDIA_ROOT and add the path to the database. You should use BinaryField instead.

answered Jun 9, 2021 at 5:11

Mohamed ElKalioby

2,3541 gold badge14 silver badges14 bronze badges

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

3 Comments

Mohamed ElKalioby Over a year ago

Yes, you can for sure.

Kevin Thomas Over a year ago

How to save it as Binary, I tried it but could not do it . I have have asked it as other question

Mohamed ElKalioby Over a year ago

You have to handle the saving manually, and don't depend of the form saving it

Allyn Villacorta · Accepted Answer · 2021-06-09 03:32:14Z

0

In PostgreSQL, it should be "BYTEA" instead of "BLOB".

answered Jun 9, 2021 at 3:32

Allyn Villacorta

611 silver badge12 bronze badges

1 Comment

Kevin Thomas Over a year ago

Good to know , Wish I get what I am seeking for

Collectives™ on Stack Overflow

Image not saving in database(mysql) and displaying null as blob in django

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related