php mysql emoji 的存储

本来是iOS开发，要往服务器上存emoji表情，无奈Java后台太菜，搞什么转义，安卓那边可以转义存到MySQL，可是iOS这边不行，昨天尝试着玩一把MySQL，整整折腾了一天才搞定。

首先说下步骤

1 ,MySQL的数据库设置成 Default collation: utf8mb4_unicode_ci  Default characterset:utf8mb4

2. MySQL的表设置成 Table collation:utf8mb4_bin

3.存emoji的字段设置字符集: utf8mb4_bin

然后改数据库的字符集，就是在my.cnf 文件中加入

 

[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 
init_connect=’SET NAMES utf8mb4’

sql_mode=NO_ENGINE_SUBSTITUTION

然后设置PHP连接数据库的字符集

 

 

header('Content-type:text/json;charset=utf8mb4');
include 'define.php';

$description = $_POST['description'];

$dsn = "mysql:host=".DB_SERVER.";dbname=".DB_NAME;

$pdo = new PDO($dsn, DB_USER,DB_PWD);
//var_dump($pdo);

$sql = "set names utf8mb4";  //连接数据库的字符集
$pdo->exec($sql);

$sql = "insert into emoji(content,name) VALUES ('$description','1')";
//$stmt = $pdo->exec($sql);
//var_dump($stmt);

try {
    $stmt = $pdo->exec($sql);
    if ($stmt) { // 插入成功返回影响的行数  插入失败返回 false
        echo json_encode(array('result' => '1'));
    }else {
        echo json_encode(array('result' => '2'));
    }
} catch (PDOException $e) {
    echo "Error!: " . $e->getMessage() . "\n";
}