By Philippe on Thursday, 04 October 2018
Posted in Technical Issues
Likes 0
Views 554
Votes 0
Hello,

Can you tell me how to incorporate a special character in a string translation, corresponding to the subject of digest emails?
What format does it take to make it work ?

Language string : COM_ES_DIGEST_EMAIL_SUBJECT

Here is the special character : https://www.compart.com/en/unicode/U+1F422

Thank you,
Philippe
Hi there,

This actually happened because the table in database do not support icon format. In order to do it you need to alter your table.
Before that you have to do a full backup (database and your site) for precaution.
[gist type="php"]
ALTER TABLE `#__social_mailer` MODIFY `title` TEXT CHARACTER SET utf8mb4 NOT NULL;
[/gist]

change the #_ to your table prefix.
·
Friday, 05 October 2018 19:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Philippe,

You can directly copy out the icon into the language string
·
Friday, 05 October 2018 11:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you. I tried. But it does not work.
When we receive an email, there is a "?" in email subject.

Philippe
·
Friday, 05 October 2018 17:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you !
It works
·
Friday, 05 October 2018 23:29
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome, glad to heard your issue resolved.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding
·
Saturday, 06 October 2018 09:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post