[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