Case Insensitive Search

Yii 1.1 General Discussion
1

Something I thought would be trivial in Yii (because it handles so many things so well) is case insensitive searching. Is there anything I can do to make the following code use an ILIKE instead of a LIKE?




public function search() {

    $criteria = new CDbCriteria;

    $criteria->compare( 'title', $this->title, true );

}

Thanks.

2

Of course I figured it out right after giving up and posting here:




$criteria->compare('LOWER(title)',strtolower($this->title),true);
3

Thanx guys, it works for me.I implemnt it to my CGridView

4

To really use ILIKE (postgress)… you can use:


$criteria->addSearchCondition('title', $this->title, true, 'AND', 'ILIKE');
5

Below adjustment will give you more results if user uses characters like ‘%’ and ‘_’:


$criteria->addSearchCondition('title', '%'.$this->title.'%', false, 'AND', 'ILIKE');

Otherwise you will get empty results if user uses characters like ‘%’ and ‘_’.

6

For Oracle DB: The following method is worked:

$criteria->compare(‘LOWER(NAME)’,strtolower($this->NAME),true,‘AND’, ‘LIKE’);

Thank you