Trigger-based logging doesn't log if just changing a letter to upper/lower case
- Turn on logging. (Admin - System Settings - Misc - Logging).
- Change the first name of a contact just changing e.g. the first letter from upper to lower case.
- Either look in the database in log_civicrm_contact or go to CiviReports - Contact Reports - Contact Logging.
- Change has not been logged.
It's because the standard collation for civi is the case-insensitive xxx_unicode_ci or possibly xxx_general_ci. You might have also changed it manually to use the same as your CMS but is likely still case-insensitive. And in mysql 8 the default utf8mb4_0900_ai_ci is also accent-insensitive (i.e. é
is treated the same as e
), if you manually changed your civi tables to use that.
The logging triggers should probably use xxx_bin
. Related but separate: https://github.com/civicrm/civicrm-core/pull/18721