[Ala-portal] MySQL - UTF-8 issue

[Marie Elise Lecoq]

Hi all,

I have an issue with the encoding when I upload data from GBIF.
In the beginning, MySQL was set to latin_1 but Dave made a modification on
the ansible script and I change the collectory database to UTF-8 as well as
the tables.

As you can see here (http://185.26.127.140/collectory/dataResource/show/dr3),
accents are not displayed. And it is the same in the database.  As data are
good in GBIF (
http://www.gbif.org/dataset/dfb4510e-068e-4a59-a1e6-9a9991b78e50), the
problem came up during the insert in the database. Any clue ?

Thanks in advance for your help,
Cheers,
Marie


--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gbif.org/pipermail/ala-portal/attachments/20150515/3edf6b58/attachment.html>