P
Prisma•2mo ago
skidy

Case insensitive for unique constraint

how do i make the name case insensitive 
@@unique([userId, name])
@@unique([userId, name])
3 Replies
Prisma AI Help
Prisma AI Help•2mo ago
You chose to compile with the bot. One moment while I piece together your answer… Based on the knowledge sources provided, there isn't a direct way to make a unique constraint case-insensitive using Prisma's schema syntax alone. However, I can suggest a few approaches that might help achieve what you're looking for: 1. Use a database-specific solution: For PostgreSQL, you could use the citext (case-insensitive text) type. This is mentioned in this GitHub issue, where a contributor suggests: 
   model Blog {
     ...
     name String @pg.Citext @unique
   }
   
   model Blog {
     ...
     name String @pg.Citext @unique
   }
However, this feature was not fully implemented at the time of that comment. 2. Create a separate lowercase field: As suggested in this discussion, you could create an additional field that stores the lowercase version of the name and make that field unique: 
   model YourModel {
     userId Int
     name String
     nameLowercase String @unique
     @@unique([userId, name])
   }
   
   model YourModel {
     userId Int
     name String
     nameLowercase String @unique
     @@unique([userId, name])
   }
You would then need to ensure that you always set and update the nameLowercase field with the lowercase version of name in your application logic. 3. Handle it at the application level: You could perform a case-insensitive check in your application code before creating or updating records. It's important to note that the specific behavior and available options can depend on the database you're using. For example, MySQL uses case-insensitive collation by default, so unique constraints would already be case-insensitive without additional configuration. If you need more specific guidance, it would be helpful to know which database you're using with Prisma. 🤔 Alright, thanks for letting us know that there's still some help needed. A team member will reply to you shortly. In the meantime, please let us know any additional info, questions, or which parts of the answer may need clarification.
Nurul
Nurul•2mo ago
Hey 👋 You would need to use citext extensions as mentioned here: https://www.prisma.io/docs/orm/prisma-schema/postgresql-extensions#what-are-postgresql-extensions
How to represent PostgreSQL extensions in your Prisma schema | Pris...
How to represent PostgreSQL extensions in your Prisma scheme, introspect extensions in your database, and apply changes to extensions with Prisma Migrate
skidy
skidyOP•2mo ago
how do i use it with @@unique?

Did you find this page helpful?