汉字转拼音声母的MSSQL函数

最新推荐文章于 2022-02-25 20:00:37 发布

原创最新推荐文章于 2022-02-25 20:00:37 发布 · 112 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#C #C++ #C# #F# #J#

其他技术专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一个SQL Server中实现的自定义函数，该函数能够将输入的汉字字符串转换为对应的拼音字符串。通过逐字符判断并查找对应拼音的方式，实现了非汉字字符的原样保留。

create   function   fun_getPY(@str   nvarchar(4000))
  returns   nvarchar(4000)
  as
  begin
  declare   @word   nchar(1),@PY   nvarchar(4000)
  set   @PY=''
  while   len(@str)>0
  begin
  set   @word=left(@str,1)
  --如果非汉字字符，返回原字符
  set   @PY=@PY+(case   when   unicode(@word)   between   19968   and   19968+20901
  then   (select   top   1   PY   from   (
  select   'A'   as   PY,N'驁'   as   word
  union   all   select   'B',N'簿'
  union   all   select   'C',N'錯'
  union   all   select   'D',N'鵽'
  union   all   select   'E',N'樲'
  union   all   select   'F',N'鰒'
  union   all   select   'G',N'腂'
  union   all   select   'H',N'夻'
  union   all   select   'J',N'攈'
  union   all   select   'K',N'穒'
  union   all   select   'L',N'鱳'
  union   all   select   'M',N'旀'
  union   all   select   'N',N'桛'
  union   all   select   'O',N'漚'
  union   all   select   'P',N'曝'
  union   all   select   'Q',N'囕'
  union   all   select   'R',N'鶸'
  union   all   select   'S',N'蜶'
  union   all   select   'T',N'籜'
  union   all   select   'W',N'鶩'
  union   all   select   'X',N'鑂'
  union   all   select   'Y',N'韻'
  union   all   select   'Z',N'咗'
  )   T
  where   word>=@word   collate   Chinese_PRC_CS_AS_KS_WS
  order   by   PY   ASC)   else   @word   end)
  set   @str=right(@str,len(@str)-1)
  end
  return   @PY
  end