Zend\Db PDO adapter ignoring charset

[Thinkscape]

Pdo Adapter (Pdo\Connection) ignores charset config option.

Beware: PDO has a buggy implementation of charset= parameter in DSN... better use this workaround to fix Adapter charset support:

$connect = new PDO(
  "mysql:host=$host;dbname=$db", 
  $user, 
  $pass, 
  array(
    PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"
  )
);

source: http://stackoverflow.com/a/7325424/181664

[froschdesign]

Notice:

charset
Prior to PHP 5.3.6, this element was silently ignored. The same behaviour can be partly replicated with the PDO::MYSQL_ATTR_INIT_COMMAND driver option…

http://php.net/manual/en/ref.pdo-mysql.connection.php

[desem]

'driver_options' => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES 'UTF8',
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET CHARACTER SET 'UTF8',
),

[Thinkscape]

Exactly why it should fly into Zend\Db

[dlu-gs]

I've sent a PR #4973

[Thinkscape]

@dlu-gs 👍

[samsonasik]

@Thinkscape #4973 merged, so should it closed ?

[ralphschindler]

Fixed (seemingly) in #4973