Doctrine2 + pdo_sqlsrv createQueryBuilder Order By with varchar field does not work

Question

I’m creating a method that takes values for createQueryBuilder() from parameters.

I tested in my local database with pdo_mysql driver and it worked perfectly, sorting both by a field of type int (id) and by a field of type varchar (title).

However, after testing in another database on an external server with pdo_sqlsrv driver (and also sqlsrv driver) it works when "order by" is by a field of type int (id), but when the sort is by a field of type varchar (title) it gives timeout on the connection.

Follow the source prints of the return by mysql database and Sqlserver database:

public function getBy($fields, $orderBy, $where = null, $params = null)
{
    if (empty($where))
        $where = '1 = 1';

    $query = $this->getEntityManager()->createQueryBuilder()
        ->select($fields)
        ->from($this->entity, $this->alias)
        ->where($where)
        ->add('orderBy', $orderBy)
        ->setFirstResult(URIHelper::$arrayParams['offset'])
        ->setMaxResults(URIHelper::$arrayParams['limit'])
        ->getQuery();

    if (!empty($params))
        $query->setParameters($params);

    print_r($query->getSQL());
    //print_r($query->getParameters());
    //print_r($query->getArrayResult());
    //die();
    return $query->getArrayResult();
}

---

OK return when using Mysql database sort title(varchar):

OK return when using Sqlserver database id(int sorting):

Return ERROR when using Sqlserver bank sorting title(varchar):