#collations — Public Fediverse posts

Just wanted to upgrade a #Postgres 13 database to Postgres 16 using the awesome tianon/postgres-upgrade #Docker image and spent the evening learning about Postgres #collations and glibc (#Debian-based containers) vs. musl (#Alpine-based ones) #incompatibilities.

Here’s a nice writeup from Daniel Nachtrub:
https://blog.nuvotex.de/postgres-2/

And here’s his alternative way:
https://blog.nuvotex.de/postgres/

I, however, just dumped everything as it wasn’t that much. Created a new 16 database and reimported the dump. But that was after several hours reading through various GitHub issues, forum comments and blog posts.

Just wanted to upgrade a #Postgres 13 database to Postgres 16 using the awesome tianon/postgres-upgrade #Docker image and spent the evening learning about Postgres #collations and glibc (#Debian-based containers) vs. musl (#Alpine-based ones) #incompatibilities.

Here’s a nice writeup from Daniel Nachtrub:
https://blog.nuvotex.de/postgres-2/

And here’s his alternative way:
https://blog.nuvotex.de/postgres/

I, however, just dumped everything as it wasn’t that much. Created a new 16 database and reimported the dump. But that was after several hours reading through various GitHub issues, forum comments and blog posts.

A 1980 photo today from the wonderful set of photos by Collations (Patrick Cummins) of the Bayview Ghost - the Hampton Court - that stood unfinished along the Bayview Extension in Toronto from 1959 through 1981. Follow the 'Link to archive record' to see all his photos.
wholemap.com/July16
#Collations #OTD #Toronto #BayviewGhost #OnThisDay #HistoricPhoto

A 1980 photo today from the wonderful set of photos by Collations (Patrick Cummins) of the Bayview Ghost - the Hampton Court - that stood unfinished along the Bayview Extension in Toronto from 1959 through 1981. Follow the 'Link to archive record' to see all his photos.
wholemap.com/July16
#Collations #OTD #Toronto #BayviewGhost #OnThisDay #HistoricPhoto

If you're, like me 😳 , just a couple of years late to #upgrade #MySQL 5.5 to 8.0, start with reading about supported / default character sets and #collations.

First, clarify what this symbolical monstrosity means: `utf8mb4_0900_ai_ci`

https://www.monolune.com/articles/what-is-the-utf8mb4_0900_ai_ci-collation/

Then, skim though the history of `utf8mb4` introduction.

https://dev.mysql.com/blog-archive/mysql-8-0-when-to-use-utf8mb3-over-utf8mb4/

Finalize with more of technical detail (#rtfm 🔖):

https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html