RE: [fw-general] Problems with 'charset' option in db configuration.

[Terre Porter]

Not sure if this might help but I just read something about the db charset.
 
this page, http://forums.zend.com/viewtopic.php?f=69
<http://forums.zend.com/viewtopic.php?f=69&p=3535> &p=3535 shows the charset
value as "utf-8" 
 
Terre 
 
edit: (resent to list, I hate reply vs reply all) 

  _____  

From: holografix . [mailto:hologra...@gmail.com] 
Sent: Tuesday, June 30, 2009 11:49 AM
To: Nabble Zend Framework General
Subject: [fw-general] Problems with 'charset' option in db configuration.



Hii.
This works fine with PHP 5.2.x but not with PHP 5.3.0.

"db" => array(
    'adapter' => 'pdo_mysql',
    "params" => array(
        "host" => 'localhost',
        "username" => 'user',
        "password" => 'xxxxxxx',
        'dbname' => 'dbtest'
        'charset' => 'utf8'

    ),
    "isDefaultTableAdapter" => true
)
            
Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in
C:\lib\php\ZendFramework\library\Zend\Db\Adapter\Pdo\Mysql.php on line 93


91    if (!empty($this->_config['charset'])) {
92        $initCommand = "SET NAMES '" . $this->_config['charset'] . "'";
93        $this->_config['driver_options'][PDO::MYSQL_ATTR_INIT_COMMAND] =
$initCommand;
94    }    

Cheers,
holo