mysql函数转义中文json(转换转义UTF-16（JSON实体）恢复正常UTF8 MySQL中)

springdk2009

于 2024-03-21 14:06:03 发布

阅读量287

点赞数 1

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： mysql json android

本文链接：https://blog.youkuaiyun.com/springdk2009/article/details/136842323

数据库专栏收录该内容

54 篇文章

订阅专栏

本文介绍了如何在MySQL中使用Unjson函数进行JSON字符串解码，特别是处理UTF-8编码的情况，展示了函数的语法及其实现原理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

时间：2021-12-23 09:44:06

DELIMITER @@ 
CREATE FUNCTION Unjson (instring TEXT CHARACTER SET utf8) 
RETURNS TEXT CHARACTER SET utf8 
BEGIN 
 
    DECLARE i INT DEFAULT 0; 
    DECLARE c VARCHAR(1); 
    DECLARE utfstr TEXT CHARACTER SET utf16 DEFAULT ""; 
    DECLARE outstring TEXT CHARACTER SET utf8 DEFAULT ""; 
 
    WHILE i < CHAR_LENGTH(instring) DO 
    SET i = i + 1; 
    SET c = SUBSTRING(instring, i, 1); 
    IF c = "\\" THEN 
     SET c = SUBSTRING(instring, i + 1, 1); 
     IF c = "u" THEN 
     SET utfstr = CONCAT(utfstr, UNHEX(SUBSTRING(instring, i + 2, 4))); 
     SET i = i + 5; 
     END IF; 
    ELSE 
     IF utfstr != "" THEN 
     SET outstring = CONCAT(outstring, CONVERT(utfstr USING utf8)); 
     SET utfstr = ""; 
     END IF; 
     SET outstring = CONCAT(outstring, c); 
    END IF; 
    END WHILE; 
    IF utfstr != "" THEN 
    SET outstring = CONCAT(outstring, CONVERT(utfstr USING utf8)); 
    END IF; 
 
    RETURN outstring; 
END@@ 
DELIMITER ;