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
Nurul
Nurul3mo ago
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-229038
GitHub
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...
SimplyEmu
SimplyEmu3mo ago
Thanks so much for the help. That is what I was having trouble finding.
Nurul
Nurul3mo ago
No worries! I am glad to hear that this was helpful.