TYPO3 Core

Recently we ran into some problems with solr and it showed up the whole cause of a series of strange issues was that the database collation (and thus any collation of newly created tables) was set to "latin1_swedish_ci".

Maybe there should be a check in the install tool (or even in the start-screen after login) which warns a user/admin of a wrong collation being set.

I guess nowaday the collation utf8_general_ci should be set by default.

This issue is especially a problem for fields holding serialized objects/data array. Unserializing them doesn't work because data seems to get garbled when being converted from latin1 to utf8.

Maybe this check should also be made for every table on its own to detect "Altlasten" when upgrading an existing installation.