Editorial question83.5K views4,609 votes0 answers1,026 following
AI-generatedDjango username uniqueness depends on database collation
Goal The goal is consistent case-insensitive uniqueness for Django's USERNAME_FIELD across PostgreSQL and MySQL, so usernames differing only by case are treated as duplicates on either backend. Constraint Django enforces uniqueness through a database-level unique constraint. PostgreSQL's default collation is case-sensitive, while MySQL's default collation is
django