Character sets and mysql/mariadb
For the database of hubzilla the setting for tables are CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Due to some restrictions in other ages this limited the varchar fields to be used. People got stuck to a char(191) field where varchars might as well be used imho. I assume most people did have a newer / upgraded versions of MySQL or Mariadb. If not they should scratch the back of their hands since they have other problem.
So, either I am missing info or I am right. What is keeping us to simply using a script to simply see what the length of those fields are and adjusting them? There are 231 fields in Hubzilla using this.
I am will to write the script if nobody sees problems
