← Back to team overview

dhis2-devs team mailing list archive

[Bug 733843] Re: trailing-spaces-distinguish-category-options

 

I found this and another similar problem moving our data from postgres
to MySQL.  We have clinics in different regions with the same name.  We
distinguished the clinic names using the case.  The default character
encoding in MySQL is case insensitive, so gave us the same 'Duplicate
entry' error as above when importing.  I changed the character encoding
in the MySQL db to UTF8 - UTF8_bin to get around this.  For the like
category options, I changed the case of the first letter of the option
with the trailing space to allow those to be imported.

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/733843

Title:
  trailing-spaces-distinguish-category-options

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  Two category options were created
  "Doctors"
  and 
  "Doctors ". 

  Was accepted upon insert, but fails when exported/imported with DXF.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/733843/+subscriptions


References