lower case table names and columns in ZF2

General discussion on Zend Server for IBM System i
Post Reply
rodn8274
Posts: 12
Joined: Mon Dec 29, 2014 5:22 pm

lower case table names and columns in ZF2

Post by rodn8274 » Wed Dec 14, 2016 9:30 pm

Does anyone know the proper configuation options to set in ZF2 to force table names and columns to lower case. I'm using pdo_odbc. Creating a db connection using the odbc driver works perfectly

Code: Select all

$Conn = new PDO("odbc:DEV", $username, $password, [ PDO::ATTR_CASE => PDO::CASE_LOWER ]);
**NOTE: DEV is my datasource name configured in my odbc.ini file on the server

I'm using ZF2 and utilizing Zend\Db\Adapter to create my connection instance. You are supposed to set up the config parameters in a local.php file like this:

Code: Select all

$db_config = array(
        'driver' => 'pdo_odbc',
        'dsn' => 'odbc:DEV',
        'driver_options' => array(
            'i5_naming' => 'DB2_I5_NAMING_ON',
            'autocommit' => 'DB_AUTOCOMMIT_OFF',
            'i5_lib' => $configs['i5_lib'],
        ),
        'platform_options' => array(
            'quote_identifiers' => false,
            'isDefaultTableAdapter' => true
        ),
        'username' => 'XXXXX',
        'password' => 'XXXXXX'      
    );
I'm struggling with how to set the PDO::ATTR_CASE => PDO::CASE_LOWER parameters in the config array. I've tried multiple scenarios but nothing seems to work. Any help would greatly be appreciated

Post Reply