0

Trying to modify a label for a relationship I got this error

   #1253 - COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'

But the structure seems to be correct and not using utf8mb4_bin. I compared with an other instance, and with the same structure I was able to modify the label

enter image description here

The table itself seems to also be properly defined: enter image description here

What is wrong?

1 Answer 1

3

Your tables have utf8mb4 at the table level but the individual columns are utf8. This is causing a mismatch for the triggers that populate the relationship cache.

My suggestion would be to run the System.utf8conversion api call, either from api explorer or command line. Make a backup first.

1
  • Dave you're the best. I worked. Thanks! May 31 at 17:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.