Email Address Authentication (dots and capitalization)
As you can know there are a lot of characters that can be used in a e-mail
address. People nowadays split some keywords in their e-mail address to
improve readability, eg:
name.surname@gmail.com
x-com.shop.support@stuff.net
However, the dot character . when using Gmail (as well as capitalization)
only improves readability, it is not taken in account as a part of e-mail
address. Thus, we can say that:
name.surname@gmail.com is the same as namesurname@gmail.com
x-com.shop.support@stuff.net is the same as x-comshopsupport@stuff.net
The problem
Most of websites use a database-driven authentication. Assume that I
registered a email (without dots) namesurname@gmail.com then, such a MySQL
query will not work as the strings differ:
SELECT * FROM users WHERE email = "name.surname@gmail.com" ;
The question
Is there any workaround to solve this kind of problem? Or do users have to
always remember, on which website they have used dots or capital letters,
even that e-mail address is still the same?
No comments:
Post a Comment