A user may be able to register with the same email address as an existing account, by changing the letter case. Drupal's uniqueness check for some user fields behaved differently depending on the database engine and its collation, and Drupal says this can lead to data integrity problems. A collation is the set of rules a database uses to compare text, such as whether A and a count as the same letter.

Who is affected

Sites on drupal/core 8.0.0 and later below 10.2.11, 10.3.0 below 10.3.9, and 11.0.0 below 11.0.8. Whether duplicate addresses get through depends on the database engine and collation in your site's $databases settings. Drupal 7 is not affected.

What to do

Update to the fixed release for your branch: 10.2.11, 10.3.9 or 11.0.8. Drupal 8, Drupal 9 and Drupal 10 before 10.2 no longer get security fixes. See SA-CORE-2024-004 and the fix.

Updating does not repair accounts that already share an address in different case. Drupal's guide Fixing emails that vary only by case covers those.

Reported by Wayne Eaker.