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

[Thomas Skierlo]

Hi Markus,

Quote: Markus Klein (liayn) wrote on Wed, 15 January 2014 20:13
----------------------------------------------------
> 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.

Yes, I can understand that. But my server, all it's connections, db and tables are forced to use "utf8_unicode_ci". Therefore it should be sufficient to just remove any initialization string. The question is: Where is the "default" locale 'utf8_general_ci' comming from? Maybe it is a bug in mysqli, defaulting to a non-set collation?

Anyhow. The problem continues. Installed "Static Info Tables" yesterday and I'm getting collation related fatals since then. Removing the static template solves them, reapplying brings them back. So I think that the core now is 'utf8_unicode_ci" ready, but are any extensions?

I really don't know what to do now. Initially all I wanted to do is test my new extension (which is made for 6.2) on 6.2.0. Since 6.2 will hopefully once be a solid base for the next years, it is important that it incorporates current standards, and all recommendations are for utf8_unicode_ci.

It seems, that nobody else is using 6.2.0 currently, since 90% of my questions here and on other lists remain unanswered. Or nobody is using utf8_unicode_ci. Maybe I should go back to general, leaving this problem to other generations :-)

Regards,

Thomas

> 
> 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
----------------------------------------------------