As for handling this in the real world, the approach I like best is to store email addresses the way they are entered, but create an index on the lowercase vers

As for handling this in the real world, the approach I like best is to store email addresses the way they are entered, but create an index on the lowercase version for lookup and uniqueness checks.