[TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

[Markus Klein]

You need it, because the connection needs to be in that collation as well.
Default seems to be utf8_general_ci.

With this setting you define the connection to use Unicode_ci and therefore the CAST method will use the correct collation,
which in turn makes the string comparison in the SQL query correct again.

Kind regards
Markus

------------------------------------------------------------
Markus Klein
TYPO3 CMS Active Contributors Team Member

> -----Original Message-----
> From: typo3-english-bounces at lists.typo3.org [mailto:typo3-english-
> bounces at lists.typo3.org] On Behalf Of Thomas Skierlo
> Sent: Wednesday, January 15, 2014 7:56 PM
> To: typo3-english at lists.typo3.org
> Subject: [TYPO3-english] Re: 6.2.0 Install Tool Update Wizard: MySQL-Error
> 
> UPDATE
> 
> About 6 hours ago the problem was solved. Download latest Master and add
> 
> SET NAMES utf8 COLLATE utf8_unicode_ci;
> 
> via Install Tool / All Configuration
> 
> My problem was gone afterwards. What I still don't understand is why this
> string is needed at all, if the server is forced to use the right collation.
> 
> That was a nasty one. Oh what a day.
> 
> Regards,
> 
> Thomas
> 
> 
> Quote: Markus Klein (liayn) wrote on Wed, 15 January 2014 19:32
> ----------------------------------------------------
> > I already found it
> >
> > http://forge.typo3.org/issues/36754
> >
> > No, it's not about not having used utf8. It is just the collation, which is IMO
> valid to be adopted as necessary.
> > And the collation of the DB has to be set before you even install TYPO3.
> >
> > Kind regards
> > Markus
> >
> > ------------------------------------------------------------
> > Markus Klein
> > TYPO3 CMS Active Contributors Team Member
> >
> >
> > > -----Original Message-----
> > > From: typo3-english-bounces (at) lists.typo3.org
> > > [mailto:typo3-english- bounces (at) lists.typo3.org] On Behalf Of
> > > Philipp Gampe
> > > Sent: Wednesday, January 15, 2014 7:13 PM
> > > To: typo3-english (at) lists.typo3.org
> > > Subject: Re: [TYPO3-english] 6.2.0 Install Tool Update Wizard:
> > > MySQL-Error
> > >
> > > Hi Markus,
> > >
> > > Markus Klein wrote:
> > >
> > > > Which patch are you referring to?
> > >
> > > Maybe the one that allowed you to insert something different than
> > > SET NAMES UTF8?
> > > I cannot find it currently, but I remember that I had a look into it once.
> > >
> > > Best regards
> > > --
> > > Philipp Gampe  PGP-Key 0AD96065  TYPO3 UG Bonn/Köln Documentation
> > > Active contributor TYPO3 CMS
> > > TYPO3 .... inspiring people to share!
> > >
> > > _______________________________________________
> > > TYPO3-english mailing list
> > > TYPO3-english (at) lists.typo3.org
> > > http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
> ----------------------------------------------------
> 
> 
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english