Mixed UTF8 and UTF8MB4 collations with _media table may cause syntax error

[dentoir]

Bins in 'ancient' TCAT installations which did not fully switch to UTF8MB4 may get failed queries with a syntax error error when JOINING on the _media table, as it will get the default UTF8MB4 character set for all its columns.

The error will look something like this:

PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' in

Short term fix is upgrading entire bin to UTF8MB4 using the upgrade script or 'downgrading' the media table to UTF8 manually. Other guilty tables could be _withheld and/or _places