SORMAS-Foundation / SORMAS-Project

SORMAS (Surveillance, Outbreak Response Management and Analysis System) is an early warning and management system to fight the spread of infectious diseases.
https://sormas.org
GNU General Public License v3.0
293 stars 143 forks source link

Infrastructure import problems related to umlauts #1583

Closed MartinWahnschaffe closed 4 years ago

MartinWahnschaffe commented 4 years ago

Bug Description

  1. Importing ü, ä, ö, etc. does not correctly work (e.g. misspelled in name) sormas_import_region_germany.txt
  2. Importing a district for a region with a ß in it's name does not work. The logic does an uppercase and this probably behaves differently for Java and JPA/SQL.. sormas_import_district_landkreise.txt

TODO

MateStrysewske commented 4 years ago

I've created some unit tests. Unfortunately, H2 seems to behave differently than PostgreSQL which is why all tests are passing right now.

We could solve the ß <-> SS problem by using toLowerCase instead of toUpperCase and maybe adding two different areas of name matching (1. match for exact name without manipulating the string, 2. use toLowerCase).