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