TYPO3 lists all tables in DB compare because of COLLATE

Question

I'm using TYPO3 8.7.4 with PHP 7.0.22 and MariaDB 10.2.7.

The DB Compare inside the InstallTool shows me that TYPO3 wants to alter all tables because the current value differs from the expected by the collation of the table:

ALTER TABLE `be_groups` CHANGE `title` `title` VARCHAR(50) DEFAULT '' NOT NULL 
Current value: title VARCHAR(50) DEFAULT '''' NOT NULL COLLATE utf8_general_ci

Answer 1

MariaDB implemented a change to the Information Schema COLUMNS table which is not backwards compatible with the output expected from the 'original' MySQL:

https://jira.mariadb.org/browse/MDEV-13132