Using utf8mb4 with php and mysql

by

MySQL’s utf8 encoding is not actual UTF-8. It’s an encoding that is kinda like UTF-8, but only supports a subset of what UTF-8 supports. utf8mb4 is actual UTF-8. This difference is an internal implementation detail of MySQL. Both look like UTF-8 on the PHP side. Whether you use utf8 or utf8mb4, PHP will get valid UTF-8 in both cases.

What you need to make sure is that the connection encoding between PHP and MySQL is set to utf8mb4. If it’s set to utf8, MySQL will not support all characters. You set this connection encoding using mysql_set_charset(), the PDO charset DSN connection parameter or whatever other method is appropriate for your database API of choice.

mb_internal_encoding just sets the default value for the $encoding parameter all mb_* functions have. It has nothing to do with MySQL.

UTF-8 and UTF-32 differ in how they encode characters. UTF-8 uses a minimum of 1 byte for a character and a maximum of 4. UTF-32 always uses 4 bytes for every character. UTF-16 uses a minimum of 2 bytes and a maximum of 4.
Due to its variable length, UTF-8 has a little bit of overhead. A character which can be encoded in 2 bytes in UTF-16 may take 3 or 4 in UTF-8; on the other hand, UTF-16 never uses less than 2 bytes. If you’re storing lots of Asian text, UTF-16 may use less storage. If most of your text is English/ASCII, UTF-8 uses less storage. UTF-32 always uses the most storage.

More Related Contents:

  1. How to update multiple MySQL table entries with different id?
  2. How to run deprecated php codes on the latest XAMPP [duplicate]
  3. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  4. How can I use PDO to fetch a results array in PHP?
  5. Is closing the mysql connection important?
  6. MySQL check if a table exists without throwing an exception
  7. Shortcomings of mysql_real_escape_string?
  8. Alternative to mysql_real_escape_string without connecting to DB
  9. HTML – Change\Update page contents without refreshing\reloading the page
  10. Calculate age based on date of birth
  11. How to write a stored procedure using phpmyadmin and how to use it through php?
  12. Doing calculations in MySQL vs PHP
  13. Geo-Search (Distance) in PHP/MySQL (Performance)
  14. PHP mysql search multiple tables using a keyword
  15. How do I count unique visitors to my site?
  16. php code to test pdo is available?
  17. PHP / MySQL build tree menu
  18. Long integer is transformed when inserted in shorter column, not truncated. Why? What is the formula?
  19. How to create Codeigniter language files from database?
  20. Laravel $q->where() between dates
  21. WordPress prepared statement with IN() condition
  22. PHP: Inserting Values from the Form into MySQL
  23. Using PHP to execute multiple MYSQL Queries
  24. Select MYSQL rows but rows into columns and column into rows
  25. How to run multiple insert query in SQL using PHP in one go?
  26. how do I get month from date in mysql
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. Can I detect and handle MySQL Warnings with PHP?
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment