Re: zend+pdo+db2

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@xxxxxxxxxxxxx
==================

.

Relevant Pages

  • zend+pdo+db2
    ... i'm not sure, if it is a php or a database problem, but i would ... i'm programming some code with zend_db and pdo to access a db2 ... localhost with mysql. ...
    (comp.lang.php)
  • zend+pdo+db2
    ... i'm not sure, if it is a php or a database problem, but i would ... i'm programming some code with zend_db and pdo to access a db2 ... localhost with mysql. ...
    (comp.lang.php)
  • Re: orchid database?
    ... My first preference for programming is C++, but I find java today provides ... Using a spreadsheet to ... >> to, MySQL and postgres. ... Open Office does have a database called base. ...
    (rec.gardens.orchids)
  • Getting errors while trying to use new Mysql 50 port and pkg
    ... One (db2) is running FreeBSD ... The other, (db3) on a new ... Db2 is running mysql 5.0.24a and has been working ...
    (freebsd-questions)
  • Re: Connect to AS/400 from .NET
    ... Provider to enable programming for ADO.NET interfaces and a set of DB2 ... > Yet another option is to have a local sql server and set it up ...
    (microsoft.public.dotnet.framework.adonet)