Set character set using MySQLi

by

It’s the same:

$mysqli->query(“SET NAMES ‘utf8′”);

From the manual:

This is the preferred way to change the charset. Using mysqli::query()
to execute SET NAMES .. is not recommended.

$mysqli->set_charset("utf8"); is just enough, let the mysqli db driver do the thing for you.

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. MySQL vs MySQLi when using PHP [closed]
  5. Single result from database using mysqli
  6. PHP error: “Cannot pass parameter 2 by reference”
  7. How to get count of rows in MySQL table using PHP?
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. How to bind mysqli bind_param arguments dynamically in PHP?
  10. How can I enable the MySQLi extension in PHP 7?
  11. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  12. Advantages Of MySQLi over MySQL [closed]
  13. check if the query results empty row mysqli [duplicate]
  14. PHP PDO and MySQLi [duplicate]
  15. Is mysql_real_escape_string() necessary when using prepared statements?
  16. Updating from MYSQL to MYSQLI [duplicate]
  17. mysqli_stmt::execute() expects exactly 0 parameters, 1 given
  18. Mysqli get_result alternative
  19. Using fetch_assoc on prepared statements
  20. Object of class mysqli_result could not be converted to string
  21. mysqli query results to show all rows
  22. Single Value Mysqli [duplicate]
  23. How to prepare statement for update query? [duplicate]
  24. How can I bind an array of strings with a mysqli prepared statement?
  25. mysqli_query(): Couldn’t fetch mysqli error [duplicate]
  26. Codeigniter: fatal error call to undefined function mysqli_init()
  27. Is there any way to print the actual query that mysqli->execute() makes?
  28. When should I close a database connection in PHP?
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. PHP and MySQLi – Cannot pass parameter 2 by reference in [duplicate]

Leave a Comment