iPhone Emoticons Insert into MySQL But Become Blank Value

iPhone emoticons insert into MySQL but become blank value

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.

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.

Sending emoticons from iPhone to CakePHP but received blank value

I think what you are trying to do is send the 'image' file and have php capture that data. In order to do that you need to 'capture' the image data with something like:

$img_data = file_get_contents('php://input');

This is PHP specific if you plan on using PHP regardless of the framework. You can read more about how to capture this data here:

http://php.net/manual/en/wrappers.php.php

UPDATE

You need to store it as a blob so it will store the image data correctly.

Emoji character (😀) is not working with utf8mb4_bin in MySQL version 5.6

The connection needs to specify utf8mb4 to MySQL. What is under the covers in DOMDocument?

/code> is hex F09F9880, which should work in a column of CHARACTER SET utf8mb4 with any utf8mb4_* collation.

And here is another link: Trouble with UTF-8 characters; what I see is not what I stored

If all else fails, execute SET NAMES utf8mb4 from PHP after establishing a connection.

function message_save ( $data = FALSE )
{   
    $project_db_config                  = array();
    $project_db_config['hostname']      = 'MY_HOST';
    $project_db_config['username']      = 'MY_USERNAME';
    $project_db_config['password']      = 'MY_PASSWORD';
    $project_db_config['database']      = 'MY_DATABASE';

    $mobile_db                          = $this->load->database( $project_db_config, TRUE );

    // other code to save message       
}

function message_save ( $data = FALSE )
{
    $mobile_db_connection = $this->load->database('admin_mobile_mh', TRUE);

    // other code to save message
}