PDO + MySQL and broken UTF-8 encoding

by

Warning: This answer applies to PHP 5.3.5 and lower. Do not use it for PHP version 5.3.6 (released in March 2011) or later.

Compare with Palec’s answer here.

Use:

$pdo = new PDO( 
    'mysql:host=hostname;dbname=defaultDbName', 
    'username', 
    'password', 
    array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") 
);

It forces UTF-8 on the PDO connection. It worked for me.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. PHP – Using PDO with IN clause array
  4. How to properly set up a PDO connection
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. strange character encoding of stored data , old script is showing them fine new one doesn’t
  8. PDO binding values for MySQL IN statement [duplicate]
  9. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  10. PDO mysql: How to know if insert was successful
  11. mysql PDO how to bind LIKE
  12. implement LIKE query in PDO
  13. PHP PDO prepared statement — MySQL LIKE query
  14. Fetching single row, single column with PDO
  15. How to install pdo driver in php docker image?
  16. How do I loop through a MySQL query via PDO in PHP?
  17. PHP PDO and MySQLi [duplicate]
  18. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  19. PDO error: SQLSTATE[HY000]: General error: 2031
  20. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  21. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  22. Use of PDO in classes [duplicate]
  23. How to handle PDO exceptions [duplicate]
  24. Check if row exists in the database before inserting
  25. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  26. PDO and MySQL Fulltext searches
  27. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  28. Save Accents in MySQL Database
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment