This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
SELECT demo.queryChildren(‘a02aee69-1183-44cb-a354-4e51caa50de8’);
执行查询出现错误: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation ‘find_in_set’
查询字符集
查询结果
在Find_in_set 函数指定参数的collate,这样就可以了。
Original: https://www.cnblogs.com/zitjubiz/p/16744470.html
Author: Gu
Title: Mysql function 自定义函数,查找子节点
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/564908/
转载文章受原作者版权保护。转载请注明原作者出处!