从获取拼音函数得到的一点体会，不对的地方欢迎指正
/*----------------------------------- 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] GOCREATE TABLE [t_GetPinyin]([py] NVARCHAR(20),[word] NVARCHAR(10) COLLATE Chinese_PRC_CS_AS_KS_WS)INSERT [t_GetPinyin] SELECT 'a' ,N'厑' UNION ALLSELECT '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',N'鶾' UNION ALL SELECT 'hang',N'沆' UNION ALL SELECT 'hao',N'兞' UNION ALL SELECT 'he',N'靏' UNION ALL SELECT 'hei',N'嬒' UNION ALL SELECT 'hen',N'恨' UNION ALL SELECT 'heng',N'堼' UNION ALL --堼囍SELECT 'hong',N'鬨' UNION ALL SELECT 'hou',N'鱟' UNION ALL SELECT 'hu',N'鸌' UNION ALL SELECT 'hua',N'蘳' UNION ALL SELECT 'huai',N'蘾' UNION ALL SELECT 'huan',N'鰀' UNION ALL SELECT 'huang',N'鎤' UNION ALL SELECT 'hui',N'顪' UNION ALL SELECT 'hun',N'諢' UNION ALL SELECT 'huo',N'夻' UNION ALL SELECT 'ji',N'驥' UNION ALL SELECT 'jia',N'嗧' UNION ALL SELECT 'jian',N'鑳' UNION ALL SELECT 'jiang',N'謽' UNION ALL SELECT 'jiao',N'釂' UNION ALL SELECT 'jie',N'繲' UNION ALL SELECT 'jin',N'齽' UNION ALL SELECT 'jing',N'竸' UNION ALL SELECT 'jiong',N'蘔' UNION ALL SELECT 'jiu',N'欍' UNION ALL SELECT 'ju',N'爠' UNION ALL SELECT 'juan',N'羂' UNION ALL SELECT 'jue',N'钁' UNION ALL SELECT 'jun',N'攈' UNION ALL SELECT 'ka',N'鉲' UNION ALL SELECT 'kai',N'乫' UNION ALL --鎎乫SELECT 'kan',N'矙' UNION ALL SELECT 'kang',N'閌' UNION ALL SELECT 'kao',N'鯌' UNION ALL SELECT 'ke',N'騍' UNION ALL SELECT 'ken',N'褃' UNION ALL SELECT 'keng',N'鏗' UNION ALL --巪乬唟厼怾SELECT 'kong',N'廤' UNION ALL SELECT 'kou',N'鷇' UNION ALL SELECT 'ku',N'嚳' UNION ALL SELECT 'kua',N'骻' UNION ALL SELECT 'kuai',N'鱠' UNION ALL SELECT 'kuan',N'窾' UNION ALL SELECT 'kuang',N'鑛' UNION ALL SELECT 'kui',N'鑎' UNION ALL SELECT 'kun',N'睏' UNION ALL SELECT 'kuo',N'穒' UNION ALL SELECT 'la',N'鞡' UNION ALL SELECT 'lai',N'籟' UNION ALL SELECT 'lan',N'糷' UNION ALL SELECT 'lang',N'唥' UNION ALL SELECT 'lao',N'軂' UNION ALL SELECT 'le',N'餎' UNION ALL SELECT 'lei',N'脷' UNION ALL --嘞脷SELECT 'leng',N'睖' UNION ALL SELECT 'li',N'瓈' UNION ALL SELECT 'lia',N'倆' UNION ALL SELECT 'lian',N'纞' UNION ALL SELECT 'liang',N'鍄' UNION ALL SELECT 'liao',N'瞭' UNION ALL SELECT 'lie',N'鱲' UNION ALL SELECT 'lin',N'轥' UNION ALL --轥拎SELECT 'ling',N'炩' UNION ALL SELECT 'liu',N'咯' UNION ALL --瓼甅囖咯SELECT 'long',N'贚' UNION ALL SELECT 'lou',N'鏤' UNION ALL SELECT 'lu',N'氇' UNION ALL SELECT 'lv',N'鑢' UNION ALL SELECT 'luan',N'亂' UNION ALL SELECT 'lue',N'擽' UNION ALL SELECT 'lun',N'論' UNION ALL SELECT 'luo',N'鱳' UNION ALL SELECT 'ma',N'嘛' UNION ALL SELECT 'mai',N'霢' UNION ALL SELECT 'man',N'蘰' UNION ALL SELECT 'mang',N'蠎' UNION ALL SELECT 'mao',N'唜' UNION ALL SELECT 'me',N'癦' UNION ALL --癦呅SELECT 'mei',N'嚜' UNION ALL SELECT 'men',N'們' UNION ALL SELECT 'meng',N'霥' UNION ALL --霿踎SELECT 'mi',N'羃' UNION ALL SELECT 'mian',N'麵' UNION ALL SELECT 'miao',N'廟' UNION ALL SELECT 'mie',N'鱴' UNION ALL --鱴瓱SELECT 'min',N'鰵' UNION ALL SELECT 'ming',N'詺' UNION ALL SELECT 'miu',N'謬' UNION ALL SELECT 'mo',N'耱' UNION ALL --耱乮SELECT 'mou',N'麰' UNION ALL --麰蟱SELECT 'mu',N'旀' UNION ALL SELECT 'na',N'魶' UNION ALL SELECT 'nai',N'錼' UNION ALL SELECT 'nan',N'婻' UNION ALL SELECT 'nang',N'齉' UNION ALL SELECT 'nao',N'臑' UNION ALL SELECT 'ne',N'呢' UNION ALL SELECT 'nei',N'焾' UNION ALL --嫩焾SELECT 'nen',N'嫩' UNION ALL SELECT 'neng',N'能' UNION ALL --莻嗯鈪銰啱SELECT 'ni',N'嬺' UNION ALL SELECT 'nian',N'艌' UNION ALL SELECT 'niang',N'釀' UNION ALL SELECT 'niao',N'脲' UNION ALL SELECT 'nie',N'钀' UNION ALL SELECT 'nin',N'拰' UNION ALL SELECT 'ning',N'濘' UNION ALL SELECT 'niu',N'靵' UNION ALL SELECT 'nong',N'齈' UNION ALL SELECT 'nou',N'譳' UNION ALL SELECT 'nu',N'搙' UNION ALL SELECT 'nv',N'衄' UNION ALL SELECT 'nue',N'瘧' UNION ALL SELECT 'nuan',N'燶' UNION ALL --硸黁燶郍SELECT 'nuo',N'桛' UNION ALL SELECT 'o',N'鞰' UNION ALL --毮夞乯鞰SELECT 'ou',N'漚' UNION ALL SELECT 'pa',N'袙' UNION ALL SELECT 'pai',N'磗' UNION ALL --鎃磗SELECT 'pan',N'鑻' UNION ALL SELECT 'pang',N'胖' UNION ALL SELECT 'pao',N'礮' UNION ALL SELECT 'pei',N'轡' UNION ALL SELECT 'pen',N'喯' UNION ALL SELECT 'peng',N'喸' UNION ALL --浌巼闏乶喸SELECT 'pi',N'鸊' UNION ALL SELECT 'pian',N'騙' UNION ALL SELECT 'piao',N'慓' UNION ALL SELECT 'pie',N'嫳' UNION ALL SELECT 'pin',N'聘' UNION ALL SELECT 'ping',N'蘋' UNION ALL SELECT 'po',N'魄' UNION ALL SELECT 'pou',N'哛' UNION ALL --兺哛SELECT 'pu',N'曝' UNION ALL SELECT 'qi',N'蟿' UNION ALL SELECT 'qia',N'髂' UNION ALL SELECT 'qian',N'縴' UNION ALL SELECT 'qiang',N'瓩' UNION ALL --羻兛瓩SELECT 'qiao',N'躈' UNION ALL SELECT 'qie',N'籡' UNION ALL SELECT 'qin',N'藽' UNION ALL SELECT 'qing',N'櫦' UNION ALL SELECT 'qiong',N'瓗' UNION ALL SELECT 'qiu',N'糗' UNION ALL SELECT 'qu',N'覻' UNION ALL SELECT 'quan',N'勸' UNION ALL SELECT 'que',N'礭' UNION ALL SELECT 'qun',N'囕' UNION ALL SELECT 'ran',N'橪' UNION ALL SELECT 'rang',N'讓' UNION ALL SELECT 'rao',N'繞' UNION ALL SELECT 're',N'熱' UNION ALL --内容过长，下续
select dbo.fn_GetPinyin(N'杨')--结果zuo
[解决办法]
手邊沒有環境測試 繁體適用嗎 我記得繁體
SELECT PATINDEX(N'%[吖-咗]%' COLLATE Chinese_PRC_CS_AS_KS_WS,N'中文字符')
似乎有問題
[解决办法]
学习
[解决办法]
支持
[解决办法]
学习,强列学习TONY哥
[解决办法]
好东东，支持！
[解决办法]
学习！
[解决办法]
此贴要火~~~~
[解决办法]
.
[解决办法]
看不懂
[解决办法]
学习。
[解决办法]
厉害~
[解决办法]
^_^
[解决办法]
jf
[解决办法]
budong!
[解决办法]
路过
[解决办法]
学习
[解决办法]
是繁体有简体的吗
[解决办法]
神贴~
[解决办法]
学习
[解决办法]
不懂
[解决办法]
支持
[解决办法]
？
看不懂
[解决办法]
学习
[解决办法]
这个很强大！
[解决办法]
太厉害了
佩服佩服
呵呵
[解决办法]
http://zhao4zhong1.download.csdn.net/
到这里下载GBK汉字拼音对照表
[解决办法]
N XX
[解决办法]
.
[解决办法]
这个真要学习
------解决方案--------------------
火了
[解决办法]
看看
[解决办法]
学习中~~~
[解决办法]
henhao duiwo meiyou yong
[解决办法]
厉害,学习了
[解决办法]
好东西~学习ing~
[解决办法]
佩服太厉害了
[解决办法]
学习 收藏了
[解决办法]
不懂哦
帮顶一下
[解决办法]
学习~
[解决办法]
收藏
[解决办法]
d
[解决办法]
学习，收藏。
[解决办法]
说实话,我一直没觉得这样的东西有什么用?
什么样的系统会用到这些功能?
不如建立一个对应表.
[解决办法]
例如:
捉这个字,其首字母到底是 z 还是 zh
爱这个字,其首字母到底是 a 还是 ai
[解决办法]
好象我理解错了楼主的意思.不好意思.
[解决办法]
强人~~！！学习~~
[解决办法]
好长！
[解决办法]
请问，多音字的咋整？
[解决办法]
学习下。。
[解决办法]
那个好长的说!
[解决办法]
这里面能把所有的字查询出来吗？
[解决办法]
。
[解决办法]
什么会应用到这个？
[解决办法]
其实，汉字编码的时候有没有对应拼音？这种查字典式的做法太繁琐了。
输入法是如何实现的？难道也是查字典？
[解决办法]
如果使用C#，微软是直接有提供相关的拼音工具库使用的。。。。
[解决办法]
不懂