Paperless-NGX: Fehler „database paperless has a collation version mismatch“ schnell behoben
Vor ein paar Tagen habe ich mein Paperless-NGX Setup auf die Version 2.19.6 aktualisiert. Eigentlich nichts Wildes, dachte ich.
Doch direkt danach wurde mein Docker Log mit Warnungen zugespammt.Und zwar mit diesen hier:
...
https://www.cleveradmin.de/blog/2025/11/paperless-ngx-collation-fehler-beheben/
#Docker #Linux #collation #datenbank #docker #paperless #postgres #Troubleshooting
Warning: rabbit hole
https://polymaths.social/@rl_dane/statuses/01K1XR4D4GCKDD7PQMSRAMV5EA
You'll recognize this one as well, no doubt. There's probably an old Usenet FAQ somewhere with it, although I haven't checked.
But it got me to thinking of when the idea of a-z collating *entirely after* A-Z became a norm; only to falter again when ASCII systems met other countries. When the era was.
I checked with a couple of my old printed dictionaries from the 20th century, and they had case-insensitive collation in English. One even put 'a' ahead of 'A'.
It's definitely thus an #ASCII notion, but did it pre-date #Unix? Did it pre-date regular expression syntax? Or shell globbing?
My initial educated guess would be that the golden period of A-Za-z was the middle 1960s with ASCII and some Unix predecessor to the early 1990s when all of the books/posts/whatnot on the new Standard C were spreading the knowledge of locales.
#UnixHistory #retrocomputing #locales #collation #RegularExpressions #fnmatch
How to Change Column Collation in MySQL
Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! #MySQL #Collation #Database #SQL #CharacterSet #UTF8MB4
https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/
...
@emchateau thanks for the hint to David J. Birnbaum's collection!
Funny coincidence, I am just on my way to what will surely be a wonderful and productive workshop on #Collation and #Visualisation (https://www.lorentzcenter.nl/seeing-the-difference-visualizing-textual-variation.html), and am reading (and can recommend) a #Balisage paper by said D. Birnbaum & Ronald Dekker in preparation: https://doi.org/10.4242/BalisageVol29.Birnbaum01
I will check out the #XSLT learning resources you mentioned and the ones other might still mention during the week, thanks again!
CC @petrichor
How to Change Column Collation in MySQL
Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands & automation tips! #MySQL #Collation #Database #SQL #CharacterSet #UTF8MB4
https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/
...
Vous n’en avez jamais assez… Assez !: https://www.aurianneor.org/vous-nen-avez-jamais-assez-assez/
#achats #argent #argentdelacommunauté #assez #aurianneor #avidité #bonmarché #collation #consommateur #diabète #étatprovidence #Ican’tgetnosatisfaction #ifIwerearichman #industriel #ingrédients #justcan’tgetenough #manger #manufacturé #marges #marques #nourriture #obésité #oxfam #pascher #platpréparé #prêt-à-manger #prix #qualité #santé #saveur #snack #subventions #ultratransformé
Livro #PythonFluente do @lr é uma preciosidade incrível. O capítulo 4 "Texto em Unicode versus Bytes" então é um arraso total
https://pythonfluente.com/#strings_bytes_files
Hoje eu consultei numa aula para falar sobre a questão da ordenação de strings de maneira adequada ao português... https://pythonfluente.com/#sorting_unicode_sec
#Collation problem identified in a project.
A good time to remind that sorting data isn't a question of yes or no. There are language specific rules to represent sorted data.
One of the functions that was mentioned in yesterday's post was EF.Functions.Collate, and collation is the thing that might cause issues when combining the DB and .NET code.
You might set collation on the DB so that upper and lower case letters will be treated the same - no distinctions. String equality, on the other hand, does recognize lower and upper characters. So if we combine the two, we get into trouble.
Let's assume that we have a simple table with a varchar column and a unique constraint on it with a collation that doesn't differentiate between lower and upper case. Now, we have the following code that loads data into memory and checks if an entry exists before adding it. Our comparison will be fruitless, but adding to the database will fail with an exception.
See the extra code below 👇
Docs 📑: https://learn.microsoft.com/en-us/ef/core/miscellaneous/collations-and-case-sensitivity
#dotnet #entityframeworkcore #effunctions #database #collation
---
If you find this useful, consider giving a like & share ♻.
Every time I fill out an online form, when I get to the State field, I imagine Tennessee saying, "Suck it, Texas. Too bad you have to do the extra click and select thing..." :-) #collation #alphabeticalorder Except having lived in both states, TN wouldn't say that. TX might if the alphabet were reversed...
