Highlighted

Issue in displaying content of email delivery

maheswarik23685

08-01-2019

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

Replies

Highlighted

Jean-Serge_Biro

MVP

08-01-2019

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

Highlighted

saraw71774576

09-01-2019

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

Highlighted

wodnicki

MVP

10-01-2019

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