TYPO3.Flow

I can confirm this issue for Debian Sqeeze with PHP 5.3.3-7+squeeze14. This is a serious issue as the data in the DB-Dump is corrupt (no DB-Backup possible).
Like Benjamin Albrecht suggested, using Doctrine SessionInitialization with 'SET NAMES utf8' seems to fix this issue.

Hi,

we are using an AOP aspect to set the doctrine SQLSesstionInit as a workaround:
With this solution it's not necessary to patch the core and the data in your DB is valid ;-)

<?php
namespace Your\Package\Aspect;

use TYPO3\Flow\Annotations as Flow;

/**
 * @Flow\Aspect
 */
class EntityManagerFactoryAspect {
    /**
     * @Flow\Around("method(TYPO3\Flow\Persistence\Doctrine\EntityManagerFactory->create())")
     * @param \TYPO3\Flow\Aop\JoinPointInterface $joinPoint The current join point
     * @return \Doctrine\ORM\EntityManager
     */
    public function sqlSessionInitAdvice(\TYPO3\Flow\Aop\JoinPointInterface $joinPoint) {
        // @var $entityManager \Doctrine\ORM\EntityManager
        $entityManager = $joinPoint->getAdviceChain()->proceed($joinPoint);
        // @var $eventManager \Doctrine\Common\EventManager
        $eventManager = $entityManager->getEventManager();

        $sql = "SET NAMES utf8;";

        $sqlSessionInit = new \Doctrine\DBAL\Event\Listeners\SQLSessionInit($sql);

        $eventManager->addEventSubscriber($sqlSessionInit);

        return $entityManager;
    }
}
?>

This github gist gave us the inspiration to our solution: https://gist.github.com/bwaidelich/3917639
(thx to @khuppenbauer on twitter for this hint)

You can use this configuration in your settings file:

TYPO3:
  Flow:
    persistence:
      backendOptions:
        driverOptions:
          1002: 'SET NAMES utf8'

Since we can't use constants in the configuration file we use it's value of 1002 (PDO::MYSQL_ATTR_INIT_COMMAND).

See also: http://www.php.net/manual/de/pdo.construct.php#96325

This Option should be the default for MySQL ... overriding is ok, but this is definitly a problem on many hosts!
Atleast it should be in the example yaml file ...