search

nopSolutions / nopCommerce

ASP.NET Core eCommerce software. nopCommerce is a free and open-source shopping cart.
https://www.nopcommerce.com
Other
9.14k stars 5.25k forks source link

[PostgreSQL] Entering an email address is case sensitive on the login page #7104

Closed exileDev closed 5 months ago

exileDev commented 5 months ago

nopCommerce version: 4.60

People who use nopcommerce v4.6 and Postgresql, emails are case sensitive at login page. However at the Customer table, "Email" column defined as "Citiext" data type which allows us to avoid case sensitivity issues. For example, we have a registered user with test@gmail.com. Select * from "Customer" where "Email" = 'Test@gmail.com' will get us the data of that user. But when we try to log in with "Test@gmail.com" we will get the "No account found" notification.

Source: https://www.nopcommerce.com/en/boards/topic/98813/email-case-sensitivity

exileDev commented 5 months ago

Closed #7104