mysql table collation
I have a database with the default collation set to
utf8mb4_0900_as_ci because i need case insensitivity but accent sensitivity. I noticed the default collation set by prisma is utf8mb4_unicode_ci. is it safe for me to manually change to the collation i need without breaking anything in Prisma? Or is there a way to have prisma set a specific collation for new tables?3 Replies
Hey @SimplyEmu 👋
We have a related feature request here:
https://github.com/prisma/prisma/issues/12845
For now, you can set the collation through
prisma migrate dev command.
https://github.com/prisma/prisma/discussions/4743#discussioncomment-229038GitHub
Specify collation in Prisma schema · Issue #12845 · prisma/prisma
Problem Not support specify collation by Prisma schema Suggested solution For example, the following statement in *.prisma datasource.db.provider: mysql in: model CollatePerTable { text String @@co...
GitHub
Is there a way to specify table collation in Prisma schema? · prism...
Hi, is there a way to specify table collation in Prisma schema? Today I tried Prisma Migrate Preview with MySQL and noticed that Prisma creates a table with the utf8mb4_unicode_ci collation. -- Cre...
Thanks so much for the help. That is what I was having trouble finding.
No worries! I am glad to hear that this was helpful.