How to store emoji string in Database using Larave

问题:

I want to store special char in database vice versa like emotive but when i try to save in database i get question marks.

Please help

回答1:

In your database.php file, make sure to set the charset and collation to utf8mb4:

'mysql' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', 'localhost'),
            'database'  => env('DB_DATABASE', 'forge'),
            'username'  => env('DB_USERNAME', 'forge'),
            'password'  => env('DB_PASSWORD', ''),
            'charset'   => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',

And your emoji column should be a String:

$table->string('emoji');

回答2:

1) Ensure you're using MYSQL 5.5.3 or later then will you be able to change the collation to utf8mb4_something,

2) Ensure table columns that are going to receive emoji have their collation set to utf8mb4_something

if still you have issue, then Edit your database.php config file and update following,

    'charset' = 'utf8mb4';
'collation' = 'utf8mb4_unicode_ci'

回答3:

In addition to the answers above, make sure to clear cache and migrate refresh to update the mysql tables. hope this helps someone

回答4:

If you are using websocket for chat and sending Emoticons, then you have to restart the websocket.

You can find and kill all the websocket processes like sudo kill (Your PID) without the round brackets.

And for the ??? marks, its okey because some browsers, or MYSQL editors not supporting Emoticons, so they show you questions (?) marks.

Regards.