Hi Greg,
Zend_Db_Adapter_Pdo_Oci is not quite bug-free, and it's likely that the
behavior you describe is simply a bug. Please feel free to create an
issue in the issue tracker so that we can track this problem to resolution:
http://framework.zend.com/issues/secure/CreateIssue!default.jspa
If you are interested in contributing a fix for this or other parts of
Zend Framework, it's really quite easy to get started:
http://framework.zend.com/community/contribute
Truly, you've already begun contributing by providing this feedback;
thanks for the report! :)
Best regards,
Darby
Greg Donald wrote:
Anyone know why CASE_FOLDING seems to only work in one direction?
I have
$options = array(
Zend_Db::CASE_FOLDING => Zend_Db::CASE_LOWER
);
And I'm using the PDO driver the docs say is required for case folding:
$db = new Zend_Db_Adapter_Pdo_Oci( array(
'username' => $config->db->username,
'password' => $config->db->password,
'dbname' => $config->db->dbname,
'host' => $config->db->host,
'port' => $config->db->port,
'options' => $options
));
So then
$select->from( $stats, array( 'count' ) )
doesn't work, but
$select->from( $stats, array( 'COUNT' ) )
does work. Why the inconsistent behaviour?
