获取中文的汉语拼音简称
来源:互联网 发布:java web报表 编辑:程序博客网 时间:2024/04/29 14:07
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
GO
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
GO
- 获取中文的汉语拼音简称
- android获取中文对应的汉语拼音
- sql 获取中文的英文简称
- 获取汉语拼音
- 获取汉语拼音
- 中文汉字替换为汉语拼音 的函数
- 获取文件路径的简称
- php 中文转成汉语拼音
- Android 中文转换汉语拼音
- 中文组织机构名与简称的识别
- 中文组织机构名与简称的识别
- java开源类库pinyin4j的使用中文转汉语拼音的工具
- C# 获取汉语拼音首字母
- [转载]获取汉语拼音
- 获取12306各个站点的简称
- 获取火车票站点名的简称
- Java_获取汉字的汉语拼音首字母Java版
- Java_获取汉字的汉语拼音首字母Java版
- 委托责任
- Blackberry引路蜂地图开发示例:放大、缩小
- Ajax与JSON的一些总结
- 如何阅读Linux源码
- 修改代码重启tomcat
- 获取中文的汉语拼音简称
- 提高班的“伞”
- error C4430: 缺少类型说明符 - 假定为 int。注意: C++ 不支持默认 int
- Android核心分析 之一分析方法论探讨之设计意图
- ceshi
- UIActionSheet实例,显示简单菜单
- 动态库和静态库的生成 linux c/c++
- Android ApiDemos示例解析(77):Graphics->RoundRects
- android-Java中实现删除文件 - 随心