How to make PDO run SET NAMES utf8 each time I connect, In ZendFramework

php zend-framework pdo zend-db-table
Itay Moav -Malimovka picture Itay Moav -Malimovka · Feb 25, 2009 · Viewed 81.3k times · Source

How to make PDO adapter run SET NAMES utf8 each time I connect, In ZendFramework. I am using an INI file to save the adapter config data. what entries should I add there?

If it wasn't clear, I am looking for the correct syntax to do it in the config.ini file of my project and not in php code, as I regard this part of the configuration code.

Answer

SchizoDuckie picture SchizoDuckie · Feb 25, 2009

fear my google-fu

$pdo = new PDO(
    'mysql:host=mysql.example.com;dbname=example_db',
    "username",
    "password",
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

first hit ;)

Related questions

php, mysql - Too many connections to database error

Good day to all. I have an odd error. I have created a chat that works like this: questions/answers are inserted into a db every 2 seconds an ajax request is sent to a php script that fetch the new …

Read More
MySql driver not installed error for Zend application

I am trying to get my ZEND application up on my apache server running on UNIX. Initially my host didnot give PDO support ,and i got it enabled by requesting them with a mail.But now I am getting an …

Read More
How do detect that transaction has already been started?

I am using Zend_Db to insert some data inside a transaction. My function starts a transaction and then calls another method that also attempts to start a transaction and of course fails(I am using MySQL5). So, the question …

Read More