ERROR: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'coalesce'
SQL: UPDATE certificates SET certificate_number=COALESCE(certificate_number,CONCAT('CERT-',YEAR(COALESCE(issue_date,NOW())),'-',LPAD(id,6,'0'))), certificate_id=COALESCE(certificate_id,CONCAT('cert-',REPLACE(UUID(),'-',''))), verification_hash=COALESCE(verification_hash,SHA2(CONCAT('certificate-',id,'-',candidate_email),256)), expiry_date=COALESCE(expiry_date,DATE_ADD(COALESCE(issue_date,NOW()),INTERVAL 3 YEAR)), status=COALESCE(status,'Active')