Hi I think the problem here is with PHP 5.3.0: Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' . This is not defined in PDO. Also think utf-8 as charset value is wrong. Issuing SET NAMES utf-8 in mysql command-line raises an error (error 1115). SET NAMES utf8; works fine.
Cheers holo 2009/6/30 Terre Porter <[email protected]> > 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&p=3535 shows the > charset value as "utf-8" > > Terre > > edit: (resent to list, I hate reply vs reply all) > > ------------------------------ > *From:* holografix . [mailto:[email protected]] > *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 >
