iPhone emoticons insert into MySQL but become blank value

by

Most iOS emojis use code points above the Basic Multilingual Plane of the Unicode table. For example, 😄 (SMILING FACE WITH OPEN MOUTH AND SMILING EYES) is at U+1F604.

OS X character viewer

Now, see http://dev.mysql.com/doc/refman/5.5/en/charset-unicode.html.

MySQL before version 5.5 only supports UTF-8 for the BMP, which includes characters between U+0000 and U+FFFF (i.e. only a subset of actual UTF-8; MySQL’s utf8 is not real UTF-8). It cannot store the character at code point U+1F604 or other similar “high characters”. MySQL 5.5+ supports utf8mb4 (actual UTF-8), utf16 and utf32, which are able to encode these characters. If you’re using MySQL 5.5+, use one of these column character sets and make sure you’re using the same charset for your connection encoding to/from PHP. If you are on MySQL < 5.5, you’ll have to use a BLOB column type. That type stores raw bytes without caring about the “characters” in it. The downside is that you won’t be able to efficiently search or index the text.

More Related Contents:

  1. How to write a REST API?
  2. The ultimate emoji encoding scheme
  3. PHP DateTime supported formats
  4. Can I call a PHP function in a JavaScript click handler?
  5. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  6. which is better every user have a table or just a row [closed]
  7. MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery
  8. Fixing broken UTF-8 encoding
  9. Insert multiple rows with one query MySQL
  10. Why is using a mysql prepared statement more secure than using the common escape functions?
  11. Export MySQL data to Excel in PHP
  12. MySQL – ignore insert error: duplicate entry
  13. localhost vs. 127.0.0.1 in mysql_connect()
  14. “slash before every quote” problem [duplicate]
  15. Call to a member function execute() on boolean in [duplicate]
  16. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  17. How to store the data in unicode in hindi language
  18. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  19. Find Point in polygon PHP
  20. phpmyadmin automatic logout time
  21. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  22. Setting a connect timeout with PDO
  23. mysql_connect(): No connection could be made because the target machine actively refused it
  24. PDO MySQL: Insert multiple rows in one query
  25. Join two tables with comma separated values
  26. Laravel nested relationships
  27. Remotely connecting to a MySQL database
  28. php/mysql zip code proximity search
  29. Mysqli multiple row insert, simple multi insert query [duplicate]
  30. Updating column so that it contains the row position

Leave a Comment