Case sensitivity
Note that case sensitivity depends on the database and database collation.
MySQL uses case insensitivity by default, while postgres is case-sensitive.
It's recommended to check out the full docs about case sensitivity (opens in a new tab).
Explicitly query for case (in)sensitive data
This is only generated for Postgres.
users, err := client.User.FindMany(
User.Email.Equals("prisMa"),
User.Email.Mode(QueryModeInsensitive), // sets case insensitivity
).Exec(ctx) +----+-----------------------------------+
| id | email |
+----+-----------------------------------+
| 61 | alice@prisma.io |
| 49 | birgitte@prisma.io |
+----+-----------------------------------+