[TYPO3-dev] Importing content using TCEMain -Text encoding
Jigal van Hemert
jigal.van.hemert at typo3.org
Thu Aug 28 13:29:36 CEST 2014
Hi,
On 28-8-2014 11:01, Patrick Schriner wrote:
> As a side note, if you want to do yourself a favor use "utf8_unicode_ci"
> (small performance hit for proper sorting).
>
> http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
Sorry, but for TYPO3 it's currently best to use utf8_general_ci. I know
there are some differences and utf8_unicode_ci is slightly better, but
some queries may end in errors if you use anything else but
utf8_general_ci ("illegal mix of collations").
I left out the details, but if you're interested I can give them to you.
--
Jigal van Hemert
TYPO3 CMS Active Contributor
TYPO3 .... inspiring people to share!
Get involved: typo3.org
More information about the TYPO3-dev
mailing list