phpzend-frameworkpdozend-db-table

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


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.


Solution

  • Itay,

    A very good question. Fortunately for you the answer is very simple:

    database.params.driver_options.1002 = "SET NAMES utf8"
    

    1002 is the value of constant PDO::MYSQL_ATTR_INIT_COMMAND

    You can't use the constant in the config.ini