How to migrate data for email field
So i have a char field which i was using to store emails. Now there are some rule/validation and processes for email fields like email validation and email normalization etc. I have to add the validation and email normalization on the field while keeping in CharField.
what is the valid and safe ways to do this?
I am using Django and Django REST framework.
What is "DRF"? And what do you mean by validation and normalization?
DRF: django-rest-framework,
validations: like it should have '@' and '.' within.
normalization: making email case in-sensitive.
main issue is already present data.
there can be 2 email which is just different in casing and if i now normalize it, they will be same and collide.
I need a safer way to handle this situation.