Cannot create a JSON value from a string with CHARACTER SET 'binary'
Hello, I am using Prisma with Planetscale, and today, for some reason, some of my schemas using JSON are encountering the error target: stickyqr.-.primary: vttablet: rpc error: code = Unknown desc = Cannot create a JSON value from a string with CHARACTER SET 'binary'. (errno 3144) (sqlstate 22032).
Everything was working fine yesterday, but this morning I ran into this issue. Nothing has changed, and I am not sure if you have any ideas on how to fix this problem?
2 Replies
Hi there, please don't ping moderators unless it's an issue of safety or to report a violation of rules
oh so sorry
That's strange, nothing has changed. I checked the table creation, and it is set to
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci, but I don't understand why this error is occurring.