[V2] Prisma unique is case sensitive

[charlelisefouasse]

Currently, on start ui V2 , prisma @unique constraint is case sensitive. You can create two items 'test' and 'Test' as it is considered different. It would be nice to have a case insensitive unique constraint

[yoannfleurydev]

My first thought is that we have to handle it at a database level (we are using Postgres, we need to check the options available)

[houssembaltii]

is citext extension for PostgreSQL a possible solution ?
https://www.prisma.io/docs/orm/prisma-schema/postgresql-extensions#how-to-introspect-postgresql-extensions

also found this : prisma/prisma#3851 (comment)

if yes , i would like to open a pull request and apply this solution