[BUGFIX] "Illegal mix of collations" in Upgrade Wizard 98/32198/2
authorLars Trebing <lars@trebing.name>
Tue, 12 Aug 2014 15:20:58 +0000 (17:20 +0200)
committerJigal van Hemert <jigal.van.hemert@typo3.org>
Fri, 15 Aug 2014 18:53:01 +0000 (20:53 +0200)
commit85408c4bfbbd941ad348ed73fa8daaa8e7f2d1e2
tree5ee0bdeecff4bf905f93500abe385a9dc218a4ce
parentc6bd628e2a8aa70746c60f733967d32804e2a38f
[BUGFIX] "Illegal mix of collations" in Upgrade Wizard

When directly comparing CAST(... AS CHAR) with a CHAR field (including
VARCHAR and TEXT) whose collation isn't the same as that of the database
connection, MySQL gives an error like this:

> Illegal mix of collations (utf8_general_ci,IMPLICIT) and
> (utf8_unicode_ci,IMPLICIT) for operation '<>'

Wrapping the right side of the comparison in CAST(... AS CHAR) as well
keeps the data unchanged while ensuring that both sides have the same
collation.

Change-Id: Icaec66412d6b6441ae30065ffb92565991e9a1e4
Resolves: #36754
Releases: 6.3, 6.2
Reviewed-on: http://review.typo3.org/32198
Reviewed-by: Jigal van Hemert <jigal.van.hemert@typo3.org>
Tested-by: Jigal van Hemert <jigal.van.hemert@typo3.org>
typo3/sysext/install/Classes/Updates/TceformsUpdateWizard.php
typo3/sysext/install/Classes/Updates/TtContentUploadsUpdateWizard.php