← Back to team overview

dhis2-devs team mailing list archive

Troubles with Accents in DHIS2.10

 

My organisationunits are not well stored. When I type a name with an accent
or cedil DHIS stores on database something else. Example:
The province "Província de Cabo Delgado" (there is an acute accent on the
first I) is stored like "Província de Cabo Delgado" on the database and it
is shown with this evil name. And check on the logs I see that bad name
again.

So I have changed mannually on the database to correct it. Then DHIS
renders it on the form correctly.

To make sure that everything is UTF-8 I made these changes:

1. Set LANG bash environment variable to LANG="en_US.UTF-8"

2. Modify JAVA_OPTS to include  -Dsun.jnu.encoding=UTF-8
-Dfile.encoding=UTF-8

3. Check dhis2 database:
postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
 dhis2     | dhis     | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/dhis


4. On my browser (Firefox and Chrome) I see UTF-8 as the charset on webapp.

So what is my mistake? This never happened before.

Thank you
Caveman

Follow ups