#36754SQL warning about collation in the install tool, Upgrade wizard
Description
My TYPO3 installation is running today’s master. All my DB tables are using the utf8_unicode_ci collation.
When I log in to the Install Tool and click on “Upgrade Wizard”, I get the following SQL warning:
exec_SELECTquery
caller t3lib_DB::exec_SELECTquery
ERROR Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘<>‘
lastBuiltQuery SELECT COUNT FROM tt_content WHERE media <> ‘’ AND CAST AS CHAR) <> media OR (CType = ‘uploads’ AND select_key != ‘’)
debug_backtrace require(init.php),install/index.php#147 // tx_install->init#346 // tx_install->updateWizard#495 // tx_install->updateWizard_parts#6401 // Tx_Install_Updates_Base->shouldRenderWizard#6442 // Tx_Install_Updates_File_TtContentUploadsUpdateWizard->checkForUpdate#157 // t3lib_DB->exec_SELECTcountRows#111 // t3lib_DB->exec_SELECTquery#337 // t3lib_DB->debug#191