Postgresql, Cdbcriteria And Compare

Yii 1.1 General Discussion
1

i try to search


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

but it searching in case sensitive format

how can i search in case insensitive format like mysql?

2

change your code to following

$criteria->compare(‘LOWER(title)’, strtolower($this->title), true);