zend_db query on connect

Question

I want the query 'SET NAMES utf8' to execute before any other queries.

But, if I execute it in the beginning of my app, it forces Zend_Db to connect to the Database, even if I'm not running any other queries. It isn't cool: My app processes lots of requests without any queries, only using cache.

How to ask Zend_Db to run 'SET NAMES utf8' right after connection?

David Snabel-Caunt · Accepted Answer · 2009-10-23 21:56:50Z

4

Sure, simply pass the 'charset' option in with the adapter params. You can do this via Zend_Config or in code:

$params = array(
    'host'           => '127.0.0.1',
    'username'       => 'webuser',
    'password'       => 'xxxxxxxx',
    'dbname'         => 'test',
    'charset'        => 'utf8'
);

$db = Zend_Db::factory('Pdo_Mysql', $params);

Reference: http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.connecting.parameters

answered Oct 23, 2009 at 21:56

David Snabel-Caunt

58.4k13 gold badges118 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Snabel-Caunt Over a year ago

Np - it's not explicitly covered in the manual, but a common requirement for sure! More questions on SO will make it easier for everyone :)

Community · Accepted Answer · 2017-05-23 11:55:41Z

0

check this link for config option , its more easier How to make PDO run SET NAMES utf8 each time I connect, In ZendFramework.

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Oct 24, 2009 at 19:29

tawfekov

5,1124 gold badges30 silver badges51 bronze badges

Collectives™ on Stack Overflow

zend_db query on connect

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related