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

by

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 😉

More Related Contents:

  1. How do detect that transaction has already been started?
  2. php, mysql – Too many connections to database error
  3. avoiding MySQL injections with the Zend_Db class
  4. Can I mix MySQL APIs in PHP?
  5. Can PHP PDO Statements accept the table or column name as parameter?
  6. Can I bind an array to an IN() condition in a PDO query?
  7. PDOException “could not find driver”
  8. Row count with PDO
  9. PDO get the last ID inserted
  10. How to view query error in PDO PHP
  11. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  12. Insert/update helper function using PDO
  13. PHP PDO – Bind table name? [duplicate]
  14. Is the leading colon for parameter names passed to PDOStatement::bindParam() optional?
  15. How to debug PDO database queries?
  16. PDO’s query vs execute
  17. Resetting array pointer in PDO results
  18. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  19. Using htmlspecialchars function with PDO prepare and execute
  20. Do SQL connections opened with PDO in PHP have to be closed
  21. Alternative for mysql_num_rows using PDO
  22. Unknown database error in PHP but it exists in PHPMyAdmin
  23. return one value from database with mysql php pdo
  24. return multiple response data in one response
  25. Running a Zend Framework action from command line
  26. PDO lastInsertId() always return 0
  27. Do PHP PDO prepared statements need to be escaped?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. session_start() takes VERY LONG TIME
  30. PDO and MySQL ‘between’

Leave a Comment