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 : https://github.com/prisma/prisma/issues/3851#issuecomment-703504485

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