Doctrine2 case-sensitive query

case-sensitive, doctrine-orm

Solution

Maybe you are using a MySQL collation ending with "_ci", like "utf8_general_ci". "ci" stands for "case insensitive". If this is the case, it is not a Doctrine issue, but a MySQL issue.

See http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

"The default character set and collation are latin1 and latin1_swedish_ci, so nonbinary string comparisons are case insensitive by default."

Problem

for some reason I need to query 'case-sensitive' in MySql + doctrine 2. Is it possible? neither ``` $em->find('UserEn', 'Bob') ``` nor ``` $q = $this->em->createQuery('select u from UserEn u where u.name = :name'); $q->setParameter('name', 'Bob'); $result = $q->getResult(); ``` is working. Any idea?

Original source