Skip to main content
Share Your Experience: Take the 2024 Developer Survey
4 votes

Do I need to change our database collations?

It's not a problem for every field, although if you want emoji support then it matters for a different reason (and you would want utf8mb4_unicode_ci everywhere, except some special-purpose fields ...
Demerit's user avatar
  • 23.1k
2 votes
Accepted

Dangerous to force a binary collation on civicrm_contact.external_identifier?

My experiments with setting external_identifier column to bin were not successful. It crashed basic functions of Civi for reasons unclear. Better is to add a hash to the data itself, thanks for the ...
CiviTeacher's user avatar
2 votes

Dangerous to force a binary collation on civicrm_contact.external_identifier?

You'd want to rebuild triggers if using trigger logging. If you have code that does a SQL join or compare on this field with another you might want to check that still works, but if it did before it ...
Demerit's user avatar
  • 23.1k

Only top scored, non community-wiki answers of a minimum length are eligible