We are using a docx file for a template and are calling the API for variables like first/last name etc. As we are working with a client who has a lot of contacts with special characters in their names (ñ, é etc.) we noticed that those aren't displayed correctly if called directly with first_name or last_name, however they ARE correctly displayed if we create a custom field in which we write the first and last name values and then instead call the custom fields.
Any idea why this could be happening?
And is there a way to call the values directly with the characters displaying correctly?
Our solution is quite cumbersome.
Thank you for help in advance!
Add a comment
|
1 Answer
It may be because of the civicrm_contact table and it's fields are not in utf8mb4_unicode_ci collation!
The Uh-oh extension can help highlight weird db issues for you, and cv api3 System.utf8conversion can convert all your tables to utf8mb4
answered Apr 22, 2022 at 11:49
-
Hi thanks for your reply! I've checked and the civicrm_contact table is correctly in utf8mb4_unicode_ci collation. Only the civi_rule tables are in utf8_general_ci which I'd assume wouldn't affect the contact table. The extension you mentioned is quite helpfull regardless, thanks for that. Any other idea what might cause my issue with the special characters?– jrockCommented Apr 22, 2022 at 12:35
-
can you see the collation for first_name and custom field column of the table? Commented Apr 22, 2022 at 12:48
-
They are both the same collation...utf8mb4_unicode_ci. It's a mystery to me why one (custom field) will display the characters correctly and the other (first_name, etc.) won't.– jrockCommented Apr 28, 2022 at 9:21