Hi Thomas,
> > 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? I'm not too deep into these DB things. Can you search the web if other people have issues with mysql and this collation (independent of TYPO3)? > > 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? Please find out which SQL statement is responsible here. Otherwise we're not able to identify if it is a Core issue or an extension issue. > > 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. I agree we should target modern standards. > > 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 :-) Like we do with every other concern in modern politics? (at least in AUT/GER) > > Regards, > > Thomas > > > Kind regards Markus ------------------------------------------------------------ Markus Klein TYPO3 CMS Active Contributors Team Member _______________________________________________ TYPO3-english mailing list TYPO3-english@lists.typo3.org http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english