Christian Welzel wrote:
> Hi there,
>
> i'm not sure, if it is a php or a database problem, but i would
> consider it the first.
> i'm programming some code with zend_db and pdo to access a db2
> database. additionally a want to be able to replace the db2 on the
> localhost with mysql (easier to maintain for a developer). This should
> be no problem, as long as i stick to ansi-sql...
> But now my problem arises:
> I initialize my table-classes in zend like this:
>
> class Core_Db_Table_Actions extends Zend_Db_Table_Abstract
> {
> protected $_name = 'actions';
> }
>
> this works fine on mysql but db2 is compaining about the not
> defined table "actions". If i write it all uppercase (ACTIONS)
> db2 is happy...
> So i wonder if it shouldn't be the task of zend/pdo to hide those
> differences from the programmer? Or have i overseen or misunderstood
> something?
>


Nope. Identifiers in SQL are case sensitive. And if you're running
MySQL on Linux instead of Windows, you'll find the table names are case
sensitive there, also (if you take the defaults).

The non-standard operation here is MySQL not having case sensitive table
names on Windows.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================