Generated Collate value
Not sure if this is relevant but I'm translating a Prisma schema into drizzle. Every Prisma table had
COLLATE utf8mb4_unicode_ci; added to the generated MySQL.
One of my drizzle tables instead has COLLATE utf8mb4_0900_ai_ci;
I'm not good enough at dbs/sql to know if this is important, a bug, or irrelevant4 Replies
we do not add anything implicitly on table creations, I suppose it's your database driver defaults
That could be, since I wasn't using databasejs (planetscale http driver) with prisma. If that's what you mean by driver
or it might be storage engine, or smthing
planetscale handles that on their own as far as I remember
we just generate create table statements
ahh ok
when I looked it up it seemed pretty inconsequential and could only maybe make a difference in edge cases with foreign languages. But if its outside of drizzle then I won't worry about it