[MySQL]如何支持utf8格式的UCS4unicode字符

filed中必须是CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci；

连接时必须set names "utf8mb4"；

这是一段PHP示例

<?php
//$emoji_1 = "?????2\x7a\xc3\x9f\xe6\xb0\xb4\xf0\x9f\x8d\x8c";
//$emoji_1 = "zß\u6c34\U0001f34c";
$emoji_1 = "\xf0\x9f\x8d\x8c";
$dbh = new PDO( 'mysql:host=localhost;dbname=test', 'root', '' );
$dbh->exec(' set names "utf8mb4" ');
$tablename = "test_9";

if($_GET['show'] == 1){
    $query = 'select * from `'.$tablename.'` where `id` = ?';

    $stm = $dbh->prepare($query);
    $stm->bindValue(1, $_GET['id'], PDO :: PARAM_INT );
    $stm->execute();
    while($row = $stm->fetch( PDO :: FETCH_ASSOC )){
        var_dump($row);
    }
}else{
    $query = 'insert into `'.$tablename.'` (`name`, `a`)values(?, ?)';
    var_dump(strlen($emoji_1));
    $stm = $dbh->prepare($query);
    $stm->bindParam(1, $emoji_1, PDO :: PARAM_STR,  strlen($emoji_1));
    $stm->bindValue(2, 3, PDO :: PARAM_INT );
    if(!$stm -> execute ()){
        var_dump($stm -> errorInfo ());
    }else{
        echo "okay.\n";
    }
}

附：

MySql中可以用UNHEX(FF...)插入HEX值,HEX值不会经过处理直接，写入内容。例如插入一个UTF8字符，输入的是这个字符的UTF8编码，而不是unicode编码

INSERT INTO my_tbl (my_col) VALUES (UNHEX('F09F949F'));

 

转载于:https://www.cnblogs.com/yiyide266/p/10491130.html