Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Alphabetische Reihenfolge bei den Lieferetiketten stimmt nicht. #83

Closed
1 task
AlwinEgger opened this issue Jan 31, 2022 · 3 comments
Closed
1 task

Alphabetische Reihenfolge bei den Lieferetiketten stimmt nicht. #83

AlwinEgger opened this issue Jan 31, 2022 · 3 comments
Assignees

Comments

@AlwinEgger
Copy link
Member

Alphabetische Reihenfolge bei den Lieferetiketten stimmt nicht.
Alle Namen mit Umlauten kommen ganz am Schluss des entsprechenden Anfangs-Buchstabens (also z.B. Bühler nach Byland). Namen mit von (z.B. von Siebenthal) kommen ganz am Schluss von allen Namen. Schafft Verwirrung in den Depots

Originally posted by @Mooshof in #77 (comment)

  • This is due to the MariaDB native ordering. We should either reorder the data in Scala OR change the native ordering on the DB (beware of the consequences in searching!)
@toggm
Copy link
Member

toggm commented Feb 1, 2022

The characterset and collaction could also be set on a query level, maybe that would help:
https://mariadb.com/kb/en/setting-character-sets-and-collations/

But then the collation/characterset needs to be defined per initiative.

@mcmpp mcmpp self-assigned this Mar 2, 2022
@ClSchreiber
Copy link
Contributor

is this a good idea? in the past, the way how kunden description has been created by OO was various, once it was Name Vorname, then Vorname Name, if ordered by Vorname Name, this will create more confusion. Or maybe I did not understand the changes that have been made...

@ClSchreiber
Copy link
Contributor

@AlwinEgger @mcmpp This is tricky, I am not sure I understand what will happen here in the future with the delivery lists, these lists are important and are used every week, we need to look at this again in detail

@mcmpp mcmpp closed this as completed Aug 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants