The default suggestion of ISPConfig on Debian 12 aka Bookworm is utf8. However the default in mariadb.conf.d is utf8mb4_general_ci. Is it possible to use utf8mb4_general_ci (or even better utf8mb4_unicode_ci) with ISPConfig or should I stick to utf8?
Let me clarify a few things for someone searching for this... 1) We are talking CHARACTER SET (i.e., utf8 or utf8mb4) and NOT collation (COLLATE), sorry for the confusion. 2) @till is right that you may use another character set for the database. However the imported file for mysql/mariadb (install/sql/ispconfig3.sql) contains DEFAULT CHARSET=utf8 for each table so that it doesn't have any influence.