PHP PDO: charset, set names?

by

You’ll have it in your connection string like:

"mysql:host=$host;dbname=$db;charset=utf8mb4"

HOWEVER, prior to PHP 5.3.6, the charset option was ignored. If you’re running an older version of PHP, you must do it like this:

$dbh = new PDO("mysql:host=$host;dbname=$db",  $user, $password);
$dbh->exec("set names utf8mb4");

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Getting raw SQL query string from PDO prepared statements
  5. PDO get the last ID inserted
  6. How do I use password hashing with PDO to make my code more secure? [closed]
  7. How to view query error in PDO PHP
  8. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  9. Insert/update helper function using PDO
  10. PDO with INSERT INTO through prepared statements [closed]
  11. PDO::fetchAll vs. PDO::fetch in a loop
  12. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  13. Resetting array pointer in PDO results
  14. Real escape string and PDO [duplicate]
  15. PDO multiple queries
  16. PHP PDO vs normal mysql_connect
  17. Can I create a database using PDO in PHP?
  18. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  19. PDO::PARAM for type decimal?
  20. PHP PDO and MySQLi [duplicate]
  21. PDO fetch one column from table into 1-dimensional array
  22. Update query with PDO and MySQL
  23. Is “SET CHARACTER SET utf8” necessary?
  24. Getting a PHP PDO connection from a mysql_connect()?
  25. Having issue with matching rows in the database
  26. Set PDO to throw exceptions by default [duplicate]
  27. PDO: MySQL server has gone away
  28. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  29. PHP/SQL Insert Error when using Named Placeholders
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment