Xrhrft

I can't store emoji characters in mysql datatbase.

I searched a lot, but again fails. I have followed this tutorial and changed these variables from Variables tab in phpmyadmin.

| Variable_name          | Value

----------------------------

character_set_client     | utf8

character_set_connection | utf8mb4

character_set_database   | utf8mb4

character_set_filesystem | binary

character_set_results    | utf8

character_set_server     | utf8mb4

character_set_system     | utf8

collation_connection     | utf8mb4_unicode_ci

collation_database       | utf8mb4_unicode_ci

collation_server         | utf8mb4_unicode_ci

NOTE: set_client and set_result are also utf8mb4 in Variables tab in phpmyadmin.

I even added these lines in my.ini file:

[client]

default-character-set = utf8mb4



[mysql]

default-character-set = utf8mb4



[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

But again no result!! I just get ???? instead of emoji. Any idea?

Edit: SHOW CREATE TABLE emoji result

 CREATE TABLE `emoji` (

 `id` int(11) NOT NULL AUTO_INCREMENT,

 `emj_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

 PRIMARY KEY (`id`),

 KEY `emj_text` (`emj_text`)

) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Paraphrasing https://stackoverflow.com/a/38363567/1766831 :

Question Marks (regular ones, not black diamonds) (Se?or for Señor):

• The bytes to be stored are not encoded as utf8mb4. Fix this.


• The column in the database is CHARACTER SET utf8mb4. Fix this.


• Also, check that the connection during reading is UTF-8. (That is, check phpmyadmin for utf8mb4.

Once ???? is stored, the Emoji is lost. That is, the INSERT side has the problem. The SELECT side may also have a problem.

I was the same problem and I follow the tutorial you posted above and alter my laravel/SQL Configuration as follows:

        'mysql' => [

        'driver'    => 'mysql',

        'host'      => env('DB_HOST', 'localhost'),

        'database'  => env('DB_DATABASE', 'database_name'),

        'username'  => env('DB_USERNAME', 'username'),

        'password'  => env('DB_PASSWORD', ''),

        'charset'   => 'utf8mb4',              //correct charset for emojis

        'collation' => 'utf8mb4_unicode_ci',   //proper collation

        'prefix'    => '',

        'strict'    => false,

    ],

and that worked!