<?php

namespace DoctrineExtensions\Tests\Query\Mysql;

use DoctrineExtensions\Tests\Query\MysqlTestCase;

class CollateTest extends MysqlTestCase
{
    public function testCollate()
    {
        $q = $this->entityManager->createQuery("SELECT COLLATE('A',latin1_german2_ci) from DoctrineExtensions\Tests\Entities\Blank");

        $this->assertEquals(
            "SELECT 'A' COLLATE latin1_german2_ci AS sclr_0 FROM Blank b0_",
            $q->getSql()
        );
    }

}