本来是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";
}