@unqiue in Prisma Schema. With mySQL/Planetscale, does case sensitivity matter?
Lets take a standard
model User { name String @unique}
model User { name String @unique}
I understand from reading up (I think at least) that mySQL doesn't care for case sensitivity when using a select query. But what about when inserting data?
Does
Debaucus
Debaucus
match the same way that
debaucus
debaucus
does? Because that would lead to issues with usernames and being unique.
If that is correct, the unique doesn't cover this edge case, how do you rectify this issue?