
Dear list members we've recently installed OTRS version 6.0.8 (Community Edition) on a Debian Linux system9.4 with MySQL-/Maria-DB 15.1 and Apache Webserver 2.4.25 as well as Perl 5, version 24. The installation process went fine until we reached the point to initialize OTRS' database with CGI-Skript installer.pl. The installer reports: "Wrong database collation (character_set_database is utf8mb4, but it needs to be utf8)." The default character encoding on MySQL-/Maria-DB is: MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE '%collation%'; +--------------------------+--------------------+ | Variable_name | Value | +--------------------------+--------------------+ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8 | | collation_connection | utf8mb4_general_ci | | collation_database | utf8mb4_general_ci | | collation_server | utf8mb4_general_ci | +--------------------------+--------------------+ Do we get rid of this error by setting character_set_database to utf8 only? In the past we encountered problems with new e-mail that comes into the OTRS ticket system and contains nasty emoticons in the subject line: as a result the OTRS system refuses to import any email anymore. So we do think it is useful to keep the utf8mb4 encoding in the database because with this encoding the database is capable to handle the incoming emoticons in subject line. Best regards, Markus -- OTRS-Administration Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilungen KIM-Basisdienste, KIM-Support 78457 Konstanz, Deutschland