如何在Orm查询中使用Laravel在数据库中存储表情符号字符串 [英] How to store emoji string in Database using Laravel with Orm Query

问题描述

我想像数据库一样将特殊字符存储在数据库中，反之亦然，但是当我尝试将特殊字符存储在数据库中时，会出现问号.

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

请帮助

推荐答案

在您的database.php文件中，确保将charset和collation设置为utf8mb4:

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');

这篇关于如何在Orm查询中使用Laravel在数据库中存储表情符号字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！