[Vtigercrm-developers] Encoding & html entities not decoded

[Rubén A. Estrada Orozco]

In my case, both browser and export display correctly:

[image: image.png]

I'm not sure what the reason in your case might be but I would say it's
some configuration. You could check how the data is being stored in the
database and what character set and collation it uses.

Saludos

Rubén


On Mon, Sep 28, 2020 at 2:25 PM Sukhdev Mohan <s.mohan at myti.it> wrote:

> Hi,
>
> I was seeing è in both browser and csv. Browser I solved by adding
> one more html_entity_decode whilst the csv it’s not working… I searched
> google and it seems that excel doesn’t support utf-8 but utf-16le but no
> luck so far.
>
> This behaviour that I’m facing is happening both on the standard export
> and to an export we developed (literally copied the standard one) in a
> custom module…
>
> Best Regards,
> *Sukhdev Mohan* | *Software Developer*
>
>
>
>
>
>
>
> Il giorno 28 set 2020, alle ore 18:52, Rubén A. Estrada Orozco <
> rulotec1 at gmail.com> ha scritto:
>
> Where are you seeing the è ? If you take a look at the source html,
> how does it look like?
> Please provide more details.
>
> Saludos
>
> Rubén
>
>
> On Sun, Sep 27, 2020 at 11:59 AM Sukhdev Mohan <s.mohan at myti.it> wrote:
>
>> Hi All,
>>
>> I’m facing a strange issue… We work with Italians and we are facing a
>> strange behaviour, html entities like è which should be converted
>> back to "è” but they aren’t… html head contains charset UTF-8 and still the
>> browser isn’t translating. This issue is faced also when they export to
>> csv. Also in some cases the accounts contains “ in their name and when
>> exporting to csv this breaks the string, how can I solve this issue?
>>
>> They are using Vtiger v7
>>
>> Best Regards,
>> *Sukhdev Mohan* | *Software Developer*
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>
> _______________________________________________
> http://www.vtiger.com/
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200929/e2103b6d/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 105508 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200929/e2103b6d/attachment-0001.png>