Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Issue in displaying content of email delivery

maheswarik23685
Level 4
Level 4

Hi All,

We have spanish content in email .We are getting some numbers when there are some characters like ó ,á. Is there any way to fix this issue?

ex: ecológico is displayed as ecológico

Kindly provide some inputs if anyone faced similar kind of issue

Thanks,

Maheswari

4 Replies
Jean-Serge_Biro
Community Advisor
Community Advisor

Hi Maheswarik,

Most of the time, it happens when the character set differs between your AC instance and your template delivery and/or HTML charset declaration.

For instance if your database/AC instance uses Win1252 or ISO8859P13 (or some tables/columns) while the html template/delivery is made with utf8 encoding/charset. Or vice&versa for charsets.


In order to be sure, you can check real encoding of your html code by using an editor as Notepad++ or Ultraedit or other editor tools with their encoding tool; and either convert the html code or/and check coherence with your AC.

Regards
J-Serge

asariaaara
Level 4
Level 4

Hi J-Serge,


how can i check what encoding my adobe campaign instance uses?

Thanks

Jonathon_wodnicki
Community Advisor
Community Advisor

Hi,

It depends on your db. For postgres run this in a js activity in a workflow, then check the audit log:

logInfo(sqlGetString('select pg_encoding_to_char(encoding) from pg_database'));

Thanks,

-Jon

saraw71774576
Level 2
Level 2

This is a good reference for HTML encoded alternatives, which you'll want to make sure you're using in your source code for special characters rather than copying from another program or letting a WYSIWYG auto-encode for you: HTML Codes - Table of ascii characters and symbols