AW: [fw-general] Zend_Db specify character set

[Stefan Gehrig]

Hi Rob,

 

there is another possibility if you're using the Zend_DB-PDO-Adapters:

$db=Zend_Db::factory('Pdo_Mysql', array(

      'host'           => 'localhost',

      'username'       => 'user',

      'password'       => 'pa$$w0rd',

      'dbname'         => 'database',

      'driver_options' => array(

            PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'

      )

));

 

This ensures that the SET-NAMES-Command is issued with every reconnect of

the underlying adapter.

 

Best regards

 

Stefan

 

Von: Bradley Holt [mailto:[EMAIL PROTECTED] 
Gesendet: Dienstag, 30. September 2008 23:04
An: Rob Riggen
Cc: fw-general@lists.zend.com
Betreff: Re: [fw-general] Zend_Db specify character set

 

Hi Rob - I usually do this by issuing a 'SET NAMES UTF8' query.

On Tue, Sep 30, 2008 at 4:59 PM, Rob Riggen <[EMAIL PROTECTED]> wrote:

Is there a way to force the character set on mysql db connections to UTF-8?

Thanks,

Rob

Robert Riggen - Zend Certified Engineer 
Big Yellow Technologies, LLC

Essex Junction, VT 05452 
802.578.6719 
[EMAIL PROTECTED]




-- 
Bradley Holt
[EMAIL PROTECTED]