Ja mam to zrobione w pliku globla.php
use Zend\Db\Adapter\Adapter as DbAdapter;
use Zend\Db\Adapter\Adapter;
$adapter = new Adapter(array(
'driver' => $config->db['adapter'],
'database' => $config->db['dbname'],
'username' => $config->db['username'],
'password' => $config->db['password'],
'hostname' => $config->db['host'],
'port' => $config->db['port'],
'charset' => $config->db['charset'],
'driver_options'=>array(PDO::MYSQL_ATTR_INIT_COMMAND=>'SET NAMES UTF8;'),
W kontrolerze możesz się do tego dobrać tak:
$this->getServiceLocator()->get('Zend\Db\Adapter\Adapter');