Zend Framework 2, Pdo Dblib Driver, How To Change Sql Platform Decorator

It seems that ZF2 with the PDO:dblib driver defaults to using the SQL92 SQL decorator. How do I use the DI system to tell it to use the SqlServer decorator instead? Just can't ge

Solution 1:

OK, well I found there's a much easier way to do it, after much digging through the Zend Framework. Simply set up your database config like this:

'db' => array(
    'driver' => 'Pdo',
    'dsn' => 'dblib:host=xxx;dbname=xxx',
    'username' => 'xxxxxxxx',
    'password' => 'xxxxxxxx',
    'charset' => 'UTF-8',
    'platform' => 'SqlServer'
)

Now I'm getting different errors, will continue the story!