When we found out MySQL utf8 isn't actually utf8..... it's a proprietary subset of utf8 that only includes up to Unicode 255..... and there is a separate "utf8mtb4" that is actual utf8.

Yup. That and the InnoDB bullshit is why I prefer PostgreSQL.

@filthyranter yeah, and migrating to utf8mtb4 is going to be a BITCH. it requires a migration for every database, for every table in every database, and every column in every table in every database.

@mjones44 Nextcloud's wiki might give you some directions for that

One thing about coming from mysql to postrges is all the nice little things that I didn't know would be so nice. Like having an actual book and guid datatype, or "delete from [table] returning [fields]"

@inaba Being able to use text instead of "blob" or "mediumblob" as datatype did it for me honestly

Wtf

@filthyranter never heard of it. link?

@mjones44 Hm, I can't seem to find it. They used to have an alternate command that prints all queries one would need to make and it worked for any database, not just one for Nextcloud. However they just let you run a occ command now, which is easier for Nextcloud users I guess.

It was essentially a concat query.