mysql获取汉字首字母拼音，包括复杂字

1. 获取汉字首字母大写如下代码

CREATE FUNCTION `F_GET_PYJM`(P_NAME VARCHAR(255)) RETURNS varchar(255) CHARSET utf8mb3
BEGIN    
	DECLARE tmp_str VARCHAR(100) CHARSET gbk DEFAULT '' ;
	DECLARE tmp_char VARCHAR(100) CHARSET gbk DEFAULT '' ; 
	DECLARE V_LEN INT;
	DECLARE V_I INT;
	DECLARE V_PY VARCHAR(100);
	SET V_LEN=CHAR_LENGTH(P_NAME);
	SET V_I=1;
	SET V_PY='';
	DROP TEMPORARY TABLE IF EXISTS TT_PYZD;
	CREATE TEMPORARY TABLE TT_PYZD (chr char(2) ,letter char(2)) DEFAULT CHARSET gbk;
	INSERT INTO TT_PYZD
	SELECT '吖 ', 'A ' UNION ALL SELECT '八 ', 'B ' UNION ALL 
	SELECT '嚓 ', 'C ' UNION ALL SELECT '咑 ', 'D ' UNION ALL 
	SELECT '妸 ', 'E ' UNION ALL SELECT '发 ', 'F ' UNION ALL 
	SELECT '旮 ', 'G ' UNION ALL SELECT '铪 ', 'H ' UNION ALL 
	SELECT '丌 ', 'J ' UNION ALL SELECT '咔 ', 'K ' UNION ALL 
	SELECT '垃 ', 'L ' UNION ALL SELECT '嘸 ', 'M ' UNION ALL 
	SELECT '拏 ', 'N ' UNION ALL SELECT '噢 ', 'O ' UNION ALL 
	SELECT '妑 ', 'P ' UNION ALL SELECT '七 ', 'Q ' UNION ALL 
	SELECT '呥 ', 'R ' UNION ALL SELECT '仨 ', 'S ' UNION ALL 
	SELECT '他 ', 'T ' UNION ALL SELECT '屲 ', 'W ' UNION ALL 
	SELECT '夕 ', 'X ' UNION ALL SELECT '丫 ', 'Y ' UNION ALL 
	SELECT '帀 ', 'Z ' ;
	WHILE V_I<=V_LEN DO 
		SET tmp_str = substring(P_NAME,V_I,1);
		IF ASCII(tmp_str)<127 THEN
			SET tmp_char=UPPER(tmp_str);
		ELSE
			SELECT letter INTO tmp_char FROM TT_PYZD WHERE chr<=tmp_str ORDER BY chr DESC LIMIT 1;
		END IF ;
		SET V_I=V_I+1;
		SET V_PY=CONCAT(V_PY,tmp_char);
	END WHILE;
	DROP TEMPORARY TABLE IF EXISTS TT_PYZD;
	RETURN V_PY;
END

2. 可能会遇见下面这个问题

问题：[Err] 1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in…
解决办法，如下两种都可：
1). 运行下面的代码，只是临时生效，重启后失效

set global log_bin_trust_function_creators=TRUE;

2). 在配置文件/etc/my.cnf的[mysqld]配置log_bin_trust_function_creators=1

3. 测试

1). 数据库表内容如下

2). 现在获取title_列的首字母，代码如下

SELECT title_,F_GET_PYJM(title_)
FROM bill_

3). 结果如下：

参照链接：https://blog.csdn.net/seasonszx/article/details/105832308