1 DROP PROCEDURE IF EXISTS `Ai_Promote`.`APWXUserAdd`
 2 DELIMITER ;;
 3 CREATE DEFINER=`root`@`%` PROCEDURE `Ai_Promote`.`APWXUserAdd`(_openid VARCHAR(50), _shopid VARCHAR(20), _shopname VARCHAR(100), _photo VARCHAR(200), _nickname VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, _phone VARCHAR(20), _city VARCHAR(50), _country VARCHAR(50), _province varchar(50), _session_Key VARCHAR(200))
 4 BEGIN
 5     DECLARE allCount INTEGER DEFAULT 0;
 6     DECLARE t_error INTEGER DEFAULT 0;
 7     DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET t_error=1;
 8     START TRANSACTION;
 9       SELECT COUNT(*) INTO allCount FROM `t_wx_user` WHERE shopid = _shopid and shopname = _shopname and openid = _openid;
10       IF allCount = 0 THEN
11             INSERT INTO `Ai_Promote`.`t_wx_user`(openid, shopid, shopname, photo, nickname, phone, phoneNumber, countryCode, role, city, country, province, session_key, add_date, unionid, gender, update_date) 
               VALUES(_openid, _shopid, _shopname, _photo, _nickname, _phone, _phone, \'86\', \'\', _city, _country, _province, _session_key, NOW(), \'\', \'\', NOW());
12       END IF;
13       IF t_error=1 THEN
14         SELECT 0;
15         ROLLBACK;
16       ELSE
17         SELECT 1;
18         COMMIT;
19       END IF;
20 END
21 ;;
22 DELIMITER ;

上面是个存储过程的例子，据说是往数据库表里面写微信小程序用户的信息的

重点看这个_nickName参数

_nickname VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,

因为有些用户的昵称是个表情，像我遇到的，一个昵称就是

版权声明：本文为wangyulong原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/wangyulong/p/15166106.html