/**
* Appends a Prepared Statement representation of the ModelCriterion onto the buffer
* Handles case insensitivity for VARCHAR columns
*
* @param string &$sb The string that will receive the Prepared Statement
* @param array $params A list to which Prepared Statement parameters will be appended
*/
protected function appendPsForUniqueClauseTo(&$sb, array &$params)
{
// LIKE is case insensitive in mySQL and SQLite, but not in PostGres
// If the column is case insensitive, use ILIKE / NOT ILIKE instead of LIKE / NOT LIKE
if ($this->ignoreStringCase) {
if ($this->getAdapter() instanceof PgsqlAdapter) {
$this->clause = preg_replace('/LIKE \\?$/i', 'ILIKE ?', $this->clause);
} else {
throw new InvalidClauseException('Case insensitive LIKE is only supported in PostreSQL');
}
}
parent::appendPsForUniqueClauseTo($sb, $params);
}