如何在每次连接时使PDO运行SET NAMES utf8,在ZendFramework中

return [
    'service_manager' => [
        'factories' => [
            Zend\Db\Adapter\Adapter::class => function ($container) {
                $config = $container->get('config');
                $dbAdapterConfig = $config['db'];

                $adapterFactory = new Zend\Db\Adapter\AdapterServiceFactory();
                $adapter = $adapterFactory->createService($container, 'Zend\Db\Adapter\Adapter', $dbAdapterConfig);

                // 在此处添加驱动程序选项以设置字符集
                $driver = $adapter->getDriver();
                $driver->getConnection()->connect();
                $driver->getConnection()->execute('SET NAMES utf8');

                return $adapter;
            },
        ],
    ],
];