Troubles with Accents in DHIS2.10

Support - Assistance technique
1

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

  1. 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

2

Hi

Can you try with the updated war from:

http://dhis2.org/download/releases/2.10/dhis.war

There was some issues with this, but it should be fixed now (it was fixed a couple of days ago)

···

–
Morten

On Sat, Dec 1, 2012 at 4:28 PM, Orvalho Augusto orvaquim@gmail.com wrote:

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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

3

Thank you!!

Yes this new war file has some angelic actions.
Caveman

···

–
Morten

On Sat, Dec 1, 2012 at 4:28 PM, Orvalho Augusto orvaquim@gmail.com wrote:

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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

4

The war file on DHIS official site is dated Dec 4. Is that war file include accent corrections?

It is because on dataset reports when I choose parent organization unit the numbers are not summed. So I am wondering if it is a bug already corrected.

Thank you

Caveman

···

–
Morten

On Sat, Dec 1, 2012 at 4:28 PM, Orvalho Augusto orvaquim@gmail.com wrote:

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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

5

Orvalho,

If you open the Help->About DHIS 2 page you can see the exact revision of the 2.10 build there.

Note that you can always get the latest 2.10 build from our CI server here:

http://apps.dhis2.org/ci/job/dhis-web-2.10/

Latest changes to the 2.10 branch are listed here:

https://code.launchpad.net/~dhis2-devs-core/dhis2/2.10

You can also subscribe to email notifications for that release branch on the link above.

Ola

···

–
Morten

On Sat, Dec 1, 2012 at 4:28 PM, Orvalho Augusto orvaquim@gmail.com wrote:

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

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp