diaspora/diaspora — Issue #2569: email not downcase'd in db
Author: lprelle
Created: 2011-12-29 19:53:01+00:00
State: open

email of some users are not downcased, so they couldn't reset the password.
just checked it, and emails are not downcased.

you could check for thoose users with this query:
SELECT distinct email FROM diaspora.users
WHERE (SUBSTRING(email, 1, 1) COLLATE utf8_bin) = UPPER(SUBSTRING(email, 1, 1));
(igonore thoose with numbers)