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");

Related Contents:

  1. Why shouldn’t I use mysql_* functions in PHP?
  2. PDOException SQLSTATE[HY000] [2002] No such file or directory
  3. PDOException “could not find driver”
  4. mysqli or PDO – what are the pros and cons? [closed]
  5. Row count with PDO
  6. PDO get the last ID inserted
  7. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  8. Getting raw SQL query string from PDO prepared statements
  9. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  10. What is the difference between MySQL, MySQLi and PDO? [closed]
  11. MySQL check if a table exists without throwing an exception
  12. How to apply bindValue method in LIMIT clause?
  13. Can I mix MySQL APIs in PHP?
  14. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  15. Installing PDO driver on MySQL Linux server
  16. PDO support for multiple queries (PDO_MYSQL, PDO_MYSQLND)
  17. Real escape string and PDO [duplicate]
  18. PDO mysql: How to know if insert was successful
  19. PHP – Using PDO with IN clause array
  20. How to properly set up a PDO connection
  21. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  22. How can I properly use a PDO object for a parameterized SELECT query
  23. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  24. PDO::PARAM for type decimal?
  25. How to view query error in PDO PHP
  26. PDO::PARAM for dates?
  27. What is the advantage of using try {} catch {} versus if {} else {}
  28. PDO binding values for MySQL IN statement [duplicate]
  29. PHP 7 RC3: How to install missing MySQL PDO
  30. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  31. How to get numeric types from MySQL using PDO?
  32. PDO::fetchAll vs. PDO::fetch in a loop
  33. How to get a query error from prepare() in PDO PHP?
  34. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  35. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  36. Do SQL connections opened with PDO in PHP have to be closed
  37. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  38. Get query back from PDO prepared statement [duplicate]
  39. Why does PDO print my password when the connection fails?
  40. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  41. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  42. Can I create a database using PDO in PHP?
  43. What is the PDO equivalent of function mysql_real_escape_string?
  44. How do I set ORDER BY params using prepared PDO statement?
  45. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  46. PDO: MySQL server has gone away
  47. SQL injection that gets around mysql_real_escape_string()
  48. Maximum execution time in phpMyadmin
  49. mysql server port number
  50. convert date string to mysql datetime field

Leave a Comment