Answers.Body: <p>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.</p>
  <p>My suggestion would be to run the System.utf8conversion api call, either from api explorer or command line. Make a backup first.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-31T17:24:05.827Z
Answers.Text: Dave you're the best. I worked. Thanks!
Answers.UserDisplayName: Guillaume Sorel
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-31T15:54:06.153Z
Answers.LastActivityDate: 2022-05-31T15:54:06.153Z
Answers.UserDisplayName: Demerit
Body: <p>Trying to modify a label for a relationship I got this error</p>
  <pre><code>   #1253 - COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'
  </code></pre>
  <p>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</p>
  <p><a href="https://i.sstatic.net/VW1RP.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/VW1RP.png" alt="enter image description here" /></a></p>
  <p>The table itself seems to also be properly defined:
  <a href="https://i.sstatic.net/5OW2A.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/5OW2A.png" alt="enter image description here" /></a></p>
  <p>What is wrong?</p>
  
Tags: <mysql>
Title: Error with charset on MySQL
ThreadText: # Error with charset on MySQL
  
  (Asked by: username_0 on 2022-05-31)
  
  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
  
  The table itself seems to also be properly defined:
  
  What is wrong?
  
  **Tags:** mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-05-31. Score: 3 | Accepted answer
  
  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.
  
  > **Comments:**
  > **username_0**: Dave you're the best. I worked. Thanks!  
  
  ---
  
  