OrderByCollate.php

<?php
/**
 * @author Antoine Hedgecock <[email protected]>
 * @author Jonas Eriksson <[email protected]>
 *
 * @copyright PMG Media Group AB
 */

namespace Domain\Repository\SqlWalker;

use Doctrine\ORM\Query\SqlWalker;

/**
 * @category Domain
 * @package Repository
 * @subpackage SqlWalker
 */
class OrderByCollate extends SqlWalker
{
    public function walkOrderByItem($item)
    {
        $sql = parent::walkOrderByItem($item);

        if ($item->expression->field == 'name' && $item->expression->identificationVariable == 'domain') {

            $sql = str_replace(' ', ' COLLATE utf8_swedish_ci ', $sql);
        }

        return $sql;
    }
}