django.db.utils.DataError: (1406, “Data too long for column ‘data_id’ at row 1490”)

One of the ways this error occurs is when you have existing data that is a varchar and you want to convert to uuid

d=Data.objects.filter(data_id__icontains=”-“)
for x in d:
  x.data_id=str(x.data_id).replace(“-“,””)
  x.save()

d=Data.objects.filter(data_id__icontains=“-“)

for x in d:

x.data_id=str(x.data_id).replace(“-“,“”)

x.save()

Posted

February 8, 2023

Denis Mwiti

Tags:

Comments