/*---------------------------------
-- Author : htl258(Tony)
-- Date : 2009-09-18 19:03:53
-- Version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2)
---------------------------------*/
--1.创建表[t_GetPinyin],目的为了提高查询效率
IF OBJECT_ID('[t_GetPinyin]') IS NOT NULL
DROP TABLE [t_GetPinyin]
GO
CREATE TABLE [t_GetPinyin]([py] NVARCHAR(20),[word] NVARCHAR(10) COLLATE Chinese_PRC_CS_AS_KS_WS)
INSERT [t_GetPinyin]
SELECT 'a' ,N'厑' UNION ALL
SELECT 'ai',N'靉' UNION ALL
SELECT 'an',N'黯' UNION ALL
SELECT 'ang',N'醠' UNION ALL
SELECT 'ao',N'驁' UNION ALL
SELECT 'ba',N'欛' UNION ALL
SELECT 'bai',N'瓸' UNION ALL --韛兡瓸
SELECT 'ban',N'瓣' UNION ALL
SELECT 'bang',N'鎊' UNION ALL
SELECT 'bao',N'鑤' UNION ALL
SELECT 'bei',N'鐾' UNION ALL
SELECT 'ben',N'輽' UNION ALL
SELECT 'beng',N'鏰' UNION ALL
SELECT 'bi',N'鼊' UNION ALL
SELECT 'bian',N'變' UNION ALL
SELECT 'biao',N'鰾' UNION ALL
SELECT 'bie',N'彆' UNION ALL
SELECT 'bin',N'鬢' UNION ALL
SELECT 'bing',N'靐' UNION ALL
SELECT 'bo',N'蔔' UNION ALL
SELECT 'bu',N'簿' UNION ALL
SELECT 'ca',N'囃' UNION ALL
SELECT 'cai',N'乲' UNION ALL --縩乲
SELECT 'can',N'爘' UNION ALL
SELECT 'cang',N'賶' UNION ALL
SELECT 'cao',N'鼜' UNION ALL
SELECT 'ce',N'簎' UNION ALL
SELECT 'cen',N'笒' UNION ALL
SELECT 'ceng',N'乽' UNION ALL --硛硳岾猠乽
SELECT 'cha',N'詫' UNION ALL
SELECT 'chai',N'囆' UNION ALL
SELECT 'chan',N'顫' UNION ALL
SELECT 'chang',N'韔' UNION ALL
SELECT 'chao',N'觘' UNION ALL
SELECT 'che',N'爡' UNION ALL
SELECT 'chen',N'讖' UNION ALL
SELECT 'cheng',N'秤' UNION ALL
SELECT 'chi',N'鷘' UNION ALL
SELECT 'chong',N'銃' UNION ALL
SELECT 'chou',N'殠' UNION ALL
SELECT 'chu',N'矗' UNION ALL
SELECT 'chuai',N'踹' UNION ALL
SELECT 'chuan',N'鶨' UNION ALL
SELECT 'chuang',N'愴' UNION ALL
SELECT 'chui',N'顀' UNION ALL
SELECT 'chun',N'蠢' UNION ALL
SELECT 'chuo',N'縒' UNION ALL
SELECT 'ci',N'嗭' UNION ALL --賜嗭
SELECT 'cong',N'謥' UNION ALL
SELECT 'cou',N'輳' UNION ALL
SELECT 'cu',N'顣' UNION ALL
SELECT 'cuan',N'爨' UNION ALL
SELECT 'cui',N'臎' UNION ALL
SELECT 'cun',N'籿' UNION ALL
SELECT 'cuo',N'錯' UNION ALL
SELECT 'da',N'橽' UNION ALL
SELECT 'dai',N'靆' UNION ALL
SELECT 'dan',N'饏' UNION ALL
SELECT 'dang',N'闣' UNION ALL
SELECT 'dao',N'纛' UNION ALL
SELECT 'de',N'的' UNION ALL
SELECT 'den',N'扽' UNION ALL
SELECT 'deng',N'鐙' UNION ALL
SELECT 'di',N'螮' UNION ALL
SELECT 'dia',N'嗲' UNION ALL
SELECT 'dian',N'驔' UNION ALL
SELECT 'diao',N'鑃' UNION ALL
SELECT 'die',N'嚸' UNION ALL --眰嚸
SELECT 'ding',N'顁' UNION ALL
SELECT 'diu',N'銩' UNION ALL
SELECT 'dong',N'霘' UNION ALL
SELECT 'dou',N'鬭' UNION ALL
SELECT 'du',N'蠹' UNION ALL
SELECT 'duan',N'叾' UNION ALL --籪叾
SELECT 'dui',N'譵' UNION ALL
SELECT 'dun',N'踲' UNION ALL
SELECT 'duo',N'鵽' UNION ALL
SELECT 'e',N'鱷' UNION ALL
SELECT 'en',N'摁' UNION ALL
SELECT 'eng',N'鞥' UNION ALL
SELECT 'er',N'樲' UNION ALL
SELECT 'fa',N'髮' UNION ALL
SELECT 'fan',N'瀪' UNION ALL
SELECT 'fang',N'放' UNION ALL
SELECT 'fei',N'靅' UNION ALL
SELECT 'fen',N'鱝' UNION ALL
SELECT 'feng',N'覅' UNION ALL
SELECT 'fo',N'梻' UNION ALL
SELECT 'fou',N'鴀' UNION ALL
SELECT 'fu',N'猤' UNION ALL --鰒猤
SELECT 'ga',N'魀' UNION ALL
SELECT 'gai',N'瓂' UNION ALL
SELECT 'gan',N'灨' UNION ALL
SELECT 'gang',N'戇' UNION ALL
SELECT 'gao',N'鋯' UNION ALL
SELECT 'ge',N'獦' UNION ALL
SELECT 'gei',N'給' UNION ALL
SELECT 'gen',N'搄' UNION ALL
SELECT 'geng',N'堩' UNION ALL --亙堩啹喼嗰
SELECT 'gong',N'兣' UNION ALL --熕贑兝兣
SELECT 'gou',N'購' UNION ALL
SELECT 'gu',N'顧' UNION ALL
SELECT 'gua',N'詿' UNION ALL
SELECT 'guai',N'恠' UNION ALL
SELECT 'guan',N'鱹' UNION ALL
SELECT 'guang',N'撗' UNION ALL
SELECT 'gui',N'鱥' UNION ALL
SELECT 'gun',N'謴' UNION ALL
SELECT 'guo',N'腂' UNION ALL
SELECT 'ha',N'哈' UNION ALL
SELECT 'hai',N'饚' UNION ALL
SELECT 'han'<
分享到:
相关推荐
ASP汉字转拼音函数,编程的时候很有用的。
支持2万+汉字转拼音
oracle汉字转拼音函数,支持拼音大小写,首字母
SQLServer汉字转全拼音函数;
汉字转拼音的Oracle函数 前言:最近处理一个特殊的问题,需要用到汉字自动转换拼音的功能。 解决:网上找了不少资料,都是有所缺陷,而且也好像很绕。其实是一个很简单的东东。后来还是自己写了一个函数获取。 这是...
汉字转换成汉语拼音的sql语句函数,下载拷贝到sql客户端使用
汉字转品应,带空格间隔和不带空格间隔,经过自己的实践整理修改过代码,基本可以覆盖99%的汉字和生僻字
EXCEL中使用的中文转拼音自定义函数,可以生成多种格式的拼音。
拼音识别汉字函数拼音识别汉字函数拼音识别汉字函数拼音识别汉字函数拼音识别汉字函数拼音识别汉字函数拼音识别汉字函数
oracle创建函数生成拼音码(汉字首字母)
vba代码实现汉字转拼音实例,很实用的资料,希望大家喜欢.
VB汉字提取拼音首字母实例函数,测试直接可以使用,包括了大部分汉字
取汉字拼音首字母的函数,取汉字拼音首字母的函数,取汉字拼音首字母的函数
汉字转换拼音函数SQL语句,希望可以帮助需要的人!
拼音和五笔码转换函数,压缩包中包含所需资源,使用方法:建立压缩包中的表和函数,执行sql就ok啦
oracle获取汉字拼音拼音首字母的功能函数 oracle 获取汉字拼音
汉字转拼音(无数据表版) 从获到拼音函数得到的一点心得体会
用sinc函数做内插,具体代码如下: T=0.1; n=0:10; x=cos(5*pi*n*T); stem(n,x); dt=0.001; t=ones(11,1)*[0:dt:1]; n=n'*ones(1,1/dt+1); y=x*sinc((t-n*T)/T); hold on; plot(t/T,y,'r') 输出图像如下:
PHP拼音转汉字函数.txt
输入汉字字符参数,返回汉字拼音的首字母!