SET NAMES utf8 in MySQL?

by

It is needed whenever you want to send data to the server having characters that cannot be represented in pure ASCII, like ‘ñ’ or ‘ö’.

That if the MySQL instance is not configured to expect UTF-8 encoding by default from client connections (many are, depending on your location and platform.)

Read http://www.joelonsoftware.com/articles/Unicode.html in case you aren’t aware how Unicode works.

Read Whether to use “SET NAMES” to see SET NAMES alternatives and what exactly is it about.

More Related Contents:

  1. UTF-8 all the way through
  2. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  3. Fixing broken UTF-8 encoding
  4. Convert latin1 characters on a UTF8 table into UTF8
  5. Storing and displaying unicode string (हिन्दी) using PHP and MySQL
  6. Is “SET CHARACTER SET utf8” necessary?
  7. UTF-8 not working in HTML forms
  8. The ultimate emoji encoding scheme
  9. Is a BLOB converted using the current/default charset in MySQL?
  10. PHP PDO and Mysql [closed]
  11. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  12. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  13. SQL injections in ADOdb and general website security
  14. PHP PDO prepared statement — MySQL LIKE query
  15. How can I use mysqli_fetch_array() twice?
  16. Best practice multi language website
  17. Unable to retrieve UTF-8 accented characters from Access via PDO_ODBC
  18. How to set UTF-8 encoding for a PHP file
  19. using nulls in a mysqli prepared statement
  20. How to run the PHP script at scheduled time
  21. How to handle error for duplicate entries?
  22. How to handle PDO exceptions [duplicate]
  23. MySql PHP select count of distinct values from comma separated data (tags)
  24. mysql_insert_id() returns 0
  25. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  26. How do I get database column names in Laravel?
  27. PDO and MySQL Fulltext searches
  28. How to avoid “Using temporary” in many-to-many queries?
  29. Using Prepared Statement, how I return the id of the inserted row?
  30. Replacing \r\n with PHP

Leave a Comment