模板
教程
环境
性能
功能
管理
【原创】oracle数据库应用中实现汉字“同音”查询
发表于：2007-07-02来源：作者：点击数：
标签：
要实现同音查询当然要先得到汉字的汉语拼音了，在网上随处可以找到ASP的汉字转拼音的代码，如以下代码： % Set d = CreateObject(Scripting.Dictionary) d.add a,-20319 d.add ai,-20317 d.add an,-20304 d.add ang,-20295 d.add ao,-20292 d.add ba,-20283
要实现“同音”查询当然要先得到汉字的汉语拼音了，在网上随处可以找到ASP的汉字转拼音的代码，如以下代码：
<% Set d = CreateObject("Scripting.Dictionary") d.add "a",-20319 d.add "ai",-20317 d.add "an",-20304 d.add "ang",-20295 d.add "ao",-20292 d.add "ba",-20283 d.add "bai",-20265 d.add "ban",-20257 d.add "bang",-20242 d.add "bao",-20230 d.add "bei",-20051 d.add "ben",-20036 d.add "beng",-20032 d.add "bi",-20026 d.add "bian",-20002 d.add "biao",-19990 d.add "bie",-19986 d.add "bin",-19982 d.add "bing",-19976 d.add "bo",-19805 d.add "bu",-19784 d.add "ca",-19775 d.add "cai",-19774 d.add "can",-19763 d.add "cang",-19756 d.add "cao",-19751 d.add "ce",-19746 d.add "ceng",-19741 d.add "cha",-19739 d.add "chai",-19728 d.add "chan",-19725 d.add "chang",-19715 d.add "chao",-19540 d.add "che",-19531 d.add "chen",-19525 d.add "cheng",-19515 d.add "chi",-19500 d.add "chong",-19484 d.add "chou",-19479 d.add "chu",-19467 d.add "chuai",-19289 d.add "chuan",-19288 d.add "chuang",-19281 d.add "chui",-19275 d.add "chun",-19270 d.add "chuo",-19263 d.add "ci",-19261 d.add "cong",-19249 d.add "cou",-19243 d.add "cu",-19242 d.add "cuan",-19238 d.add "cui",-19235 d.add "cun",-19227 d.add "cuo",-19224 d.add "da",-19218 d.add "dai",-19212 d.add "dan",-19038 d.add "dang",-19023 d.add "dao",-19018 d.add "de",-19006 d.add "deng",-19003 d.add "di",-18996 d.add "dian",-18977 d.add "diao",-18961 d.add "die",-18952 d.add "ding",-18783 d.add "diu",-18774 d.add "dong",-18773 d.add "dou",-18763 d.add "du",-18756 d.add "duan",-18741 d.add "dui",-18735 d.add "dun",-18731 d.add "duo",-18722 d.add "e",-18710 d.add "en",-18697 d.add "er",-18696 d.add "fa",-18526 d.add "fan",-18518 d.add "fang",-18501 d.add "fei",-18490 d.add "fen",-18478 d.add "feng",-18463 d.add "fo",-18448 d.add "fou",-18447 d.add "fu",-18446 d.add "ga",-18239 d.add "gai",-18237 d.add "gan",-18231 d.add "gang",-18220 d.add "gao",-18211 d.add "ge",-18201 d.add "gei",-18184 d.add "gen",-18183 d.add "geng",-18181 d.add "gong",-18012 d.add "gou",-17997 d.add "gu",-17988 d.add "gua",-17970 d.add "guai",-17964 d.add "guan",-17961 d.add "guang",-17950 d.add "gui",-17947 d.add "gun",-17931 d.add "guo",-17928 d.add "ha",-17922 d.add "hai",-17759 d.add "han",-17752 d.add "hang",-17733 d.add "hao",-17730 d.add "he",-17721 d.add "hei",-17703 d.add "hen",-17701 d.add "heng",-17697 d.add "hong",-17692 d.add "hou",-17683 d.add "hu",-17676 d.add "hua",-17496 d.add "huai",-17487 d.add "huan",-17482 d.add "huang",-17468 d.add "hui",-17454 d.add "hun",-17433 d.add "huo",-17427 d.add "ji",-17417 d.add "jia",-17202 d.add "jian",-17185 d.add "jiang",-16983 d.add "jiao",-16970 d.add "jie",-16942 d.add "jin",-16915 d.add "jing",-16733 d.add "jiong",-16708 d.add "jiu",-16706 d.add "ju",-16689 d.add "juan",-16664 d.add "jue",-16657 d.add "jun",-16647 d.add "ka",-16474 d.add "kai",-16470 d.add "kan",-16465 d.add "kang",-16459 d.add "kao",-16452 d.add "ke",-16448 d.add "ken",-16433 d.add "keng",-16429 d.add "kong",-16427 d.add "kou",-16423 d.add "ku",-16419 d.add "kua",-16412 d.add "kuai",-16407 d.add "kuan",-16403 d.add "kuang",-16401 d.add "kui",-16393 d.add "kun",-16220 d.add "kuo",-16216 d.add "la",-16212 d.add "lai",-16205 d.add "lan",-16202 d.add "lang",-16187 d.add "lao",-16180 d.add "le",-16171 d.add "lei",-16169 d.add "leng",-16158 d.add "li",-16155 d.add "lia",-15959 d.add "lian",-15958 d.add "liang",-15944 d.add "liao",-15933 d.add "lie",-15920 d.add "lin",-15915 d.add "ling",-15903 d.add "liu",-15889 d.add "long",-15878 d.add "lou",-15707 d.add "lu",-15701 d.add "lv",-15681 d.add "luan",-15667 d.add "lue",-15661 d.add "lun",-15659 d.add "luo",-15652 d.add "ma",-15640 d.add "mai",-15631 d.add "man",-15625 d.add "mang",-15454 d.add "mao",-15448 d.add "me",-15436 d.add "mei",-15435 d.add "men",-15419 d.add "meng",-15416 d.add "mi",-15408 d.add "mian",-15394 d.add "miao",-15385 d.add "mie",-15377 d.add "min",-15375 d.add "ming",-15369 d.add "miu",-15363 d.add "mo",-15362 d.add "mou",-15183 d.add "mu",-15180 d.add "na",-15165 d.add "nai",-15158 d.add "nan",-15153 d.add "nang",-15150 d.add "nao",-15149 d.add "ne",-15144 d.add "nei",-15143 d.add "nen",-15141 d.add "neng",-15140 d.add "ni",-15139 d.add "nian",-15128 d.add "niang",-15121 d.add "niao",-15119 d.add "nie",-15117 d.add "nin",-15110 d.add "ning",-15109 d.add "niu",-14941 d.add "nong",-14937 d.add "nu",-14933 d.add "nv",-14930 d.add "nuan",-14929 d.add "nue",-14928 d.add "nuo",-14926 d.add "o",-14922 d.add "ou",-14921 d.add "pa",-14914 d.add "pai",-14908 d.add "pan",-14902 d.add "pang",-14894 d.add "pao",-14889 d.add "pei",-14882 d.add "pen",-14873 d.add "peng",-14871 d.add "pi",-14857 d.add "pian",-14678 d.add "piao",-14674 d.add "pie",-14670 d.add "pin",-14668 d.add "ping",-14663 d.add "po",-14654 d.add "pu",-14645 d.add "qi",-14630 d.add "qia",-14594 d.add "qian",-14429 d.add "qiang",-14407 d.add "qiao",-14399 d.add "qie",-14384 d.add "qin",-14379 d.add "qing",-14368 d.add "qiong",-14355 d.add "qiu",-14353 d.add "qu",-14345 d.add "quan",-14170 d.add "que",-14159 d.add "qun",-14151 d.add "ran",-14149 d.add "rang",-14145 d.add "rao",-14140 d.add "re",-14137 d.add "ren",-14135 d.add "reng",-14125 d.add "ri",-14123 d.add "rong",-14122 d.add "rou",-14112 d.add "ru",-14109 d.add "ruan",-14099 d.add "rui",-14097 d.add "run",-14094 d.add "ruo",-14092 d.add "sa",-14090 d.add "sai",-14087 d.add "san",-14083 d.add "sang",-13917 d.add "sao",-13914 d.add "se",-13910 d.add "sen",-13907 d.add "seng",-13906 d.add "sha",-13905 d.add "shai",-13896 d.add "shan",-13894 d.add "shang",-13878 d.add "shao",-13870 d.add "she",-13859 d.add "shen",-13847 d.add "sheng",-13831 d.add "shi",-13658 d.add "shou",-13611 d.add "shu",-13601 d.add "shua",-13406 d.add "shuai",-13404 d.add "shuan",-13400 d.add "shuang",-13398 d.add "shui",-13395 d.add "shun",-13391 d.add "shuo",-13387 d.add "si",-13383 d.add "song",-13367 d.add "sou",-13359 d.add "su",-13356 d.add "suan",-13343 d.add "sui",-13340 d.add "sun",-13329 d.add "suo",-13326 d.add "ta",-13318 d.add "tai",-13147 d.add "tan",-13138 d.add "tang",-13120 d.add "tao",-13107 d.add "te",-13096 d.add "teng",-13095 d.add "ti",-13091 d.add "tian",-13076 d.add "tiao",-13068 d.add "tie",-13063 d.add "ting",-13060 d.add "tong",-12888 d.add "tou",-12875 d.add "tu",-12871 d.add "tuan",-12860 d.add "tui",-12858 d.add "tun",-12852 d.add "tuo",-12849 d.add "wa",-12838 d.add "wai",-12831 d.add "wan",-12829 d.add "wang",-12812 d.add "wei",-12802 d.add "wen",-12607 d.add "weng",-12597 d.add "wo",-12594 d.add "wu",-12585 d.add "xi",-12556 d.add "xia",-12359 d.add "xian",-12346 d.add "xiang",-12320 d.add "xiao",-12300 d.add "xie",-12120 d.add "xin",-12099 d.add "xing",-12089 d.add "xiong",-12074 d.add "xiu",-12067 d.add "xu",-12058 d.add "xuan",-12039 d.add "xue",-11867 d.add "xun",-11861 d.add "ya",-11847 d.add "yan",-11831 d.add "yang",-11798 d.add "yao",-11781 d.add "ye",-11604 d.add "yi",-11589 d.add "yin",-11536 d.add "ying",-11358 d.add "yo",-11340 d.add "yong",-11339 d.add "you",-11324 d.add "yu",-11303 d.add "yuan",-11097 d.add "yue",-11077 d.add "yun",-11067 d.add "za",-11055 d.add "zai",-11052 d.add "zan",-11045 d.add "zang",-11041 d.add "zao",-11038 d.add "ze",-11024 d.add "zei",-11020 d.add "zen",-11019 d.add "zeng",-11018 d.add "zha",-11014 d.add "zhai",-10838 d.add "zhan",-10832 d.add "zhang",-10815 d.add "zhao",-10800 d.add "zhe",-10790 d.add "zhen",-10780 d.add "zheng",-10764 d.add "zhi",-10587 d.add "zhong",-10544 d.add "zhou",-10533 d.add "zhu",-10519 d.add "zhua",-10331 d.add "zhuai",-10329 d.add "zhuan",-10328 d.add "zhuang",-10322 d.add "zhui",-10315 d.add "zhun",-10309 d.add "zhuo",-10307 d.add "zi",-10296 d.add "zong",-10281 d.add "zou",-10274 d.add "zu",-10270 d.add "zuan",-10262 d.add "zui",-10260 d.add "zun",-10256 d.add "zuo",-10254 function g(num) if num>0 and num<160 then g=chr(num) else if num<-20319 or num>-10247 then g="" else a=d.Items b=d.keys for i=d.count-1 to 0 step -1 if a(i)<=num then exit for next g=b(i) end if end if end function function c(str) c="" for i=1 to len(str) c=c&g(asc(mid(str,i,1))) next end function response.write c(request("hz")) %> <form method=post> 请在此处输入中文：<input name=hz> </form>
以上代码的原理十分简单，这里我不多说了，下面我们把上面的码表导入oracle表中，不过要注意一下，oracle中内置的ASCII()函数于VB中的ASC()函数的返回值范围不同，我们需要加上65536得出的才是oracle中汉字的ascii码，如：VB中ASC("啊")=-20319， 在oracle中ASCII("啊")=-20319+65536=45217。以下是生成oracle码表的脚本。
/*TABLE NAME:T_PINYIN*//*CREATE TIME:2005-2-19 0:19:26*/
CREATE TABLE BJXKS."T_PINYIN" ( HZPY VARCHAR(10), NUM INT)/
INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#★@#,@#41455@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#*@#,@#255@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#*@#,@#1@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#a@#,@#45217@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ai@#,@#45219@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#an@#,@#45232@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ang@#,@#45241@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ao@#,@#45244@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ba@#,@#45253@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bai@#,@#45271@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ban@#,@#45279@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bang@#,@#45294@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bao@#,@#45306@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bei@#,@#45485@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ben@#,@#45500@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#beng@#,@#45504@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bi@#,@#45510@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bian@#,@#45534@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#biao@#,@#45546@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bie@#,@#45550@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bin@#,@#45554@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bing@#,@#45560@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bo@#,@#45731@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#bu@#,@#45752@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ca@#,@#45761@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cai@#,@#45762@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#can@#,@#45773@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cang@#,@#45780@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cao@#,@#45785@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ce@#,@#45790@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ceng@#,@#45795@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cha@#,@#45797@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chai@#,@#45808@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chan@#,@#45811@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chang@#,@#45821@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chao@#,@#45996@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#che@#,@#46005@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chen@#,@#46011@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cheng@#,@#46021@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chi@#,@#46036@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chong@#,@#46052@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chou@#,@#46057@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chu@#,@#46069@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chuai@#,@#46247@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chuan@#,@#46248@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chuang@#,@#46255@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chui@#,@#46261@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chun@#,@#46266@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#chuo@#,@#46273@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ci@#,@#46275@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cong@#,@#46287@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cou@#,@#46293@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cu@#,@#46294@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cuan@#,@#46298@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cui@#,@#46301@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cun@#,@#46309@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#cuo@#,@#46312@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#da@#,@#46318@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dai@#,@#46324@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dan@#,@#46498@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dang@#,@#46513@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dao@#,@#46518@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#de@#,@#46530@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#deng@#,@#46533@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#di@#,@#46540@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dian@#,@#46559@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#diao@#,@#46575@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#die@#,@#46584@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ding@#,@#46753@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#diu@#,@#46762@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dong@#,@#46763@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dou@#,@#46773@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#du@#,@#46780@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#duan@#,@#46795@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dui@#,@#46801@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#dun@#,@#46805@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#duo@#,@#46814@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#e@#,@#46826@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#en@#,@#46839@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#er@#,@#46840@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fa@#,@#47010@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fan@#,@#47018@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fang@#,@#47035@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fei@#,@#47046@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fen@#,@#47058@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#feng@#,@#47073@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fo@#,@#47088@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fou@#,@#47089@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#fu@#,@#47090@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ga@#,@#47297@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gai@#,@#47299@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gan@#,@#47305@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gang@#,@#47316@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gao@#,@#47325@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ge@#,@#47335@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gei@#,@#47352@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gen@#,@#47353@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#geng@#,@#47355@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gong@#,@#47524@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gou@#,@#47539@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gu@#,@#47548@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gua@#,@#47566@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#guai@#,@#47572@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#guan@#,@#47575@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#guang@#,@#47586@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gui@#,@#47589@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#gun@#,@#47605@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#guo@#,@#47608@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ha@#,@#47614@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hai@#,@#47777@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#han@#,@#47784@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hang@#,@#47803@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hao@#,@#47806@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#he@#,@#47815@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hei@#,@#47833@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hen@#,@#47835@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#heng@#,@#47839@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hong@#,@#47844@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hou@#,@#47853@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hu@#,@#47860@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hua@#,@#48040@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#huai@#,@#48049@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#huan@#,@#48054@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#huang@#,@#48068@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hui@#,@#48082@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#hun@#,@#48103@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#huo@#,@#48109@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ji@#,@#48119@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jia@#,@#48334@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jian@#,@#48351@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jiang@#,@#48553@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jiao@#,@#48566@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jie@#,@#48594@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jin@#,@#48621@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jing@#,@#48803@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jiong@#,@#48828@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jiu@#,@#48830@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ju@#,@#48847@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#juan@#,@#48872@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jue@#,@#48879@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#jun@#,@#48889@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ka@#,@#49062@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kai@#,@#49066@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kan@#,@#49071@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kang@#,@#49077@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kao@#,@#49084@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ke@#,@#49088@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ken@#,@#49103@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#keng@#,@#49107@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kong@#,@#49109@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kou@#,@#49113@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ku@#,@#49117@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kua@#,@#49124@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kuai@#,@#49129@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kuan@#,@#49133@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kuang@#,@#49135@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kui@#,@#49143@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kun@#,@#49316@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#kuo@#,@#49320@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#la@#,@#49324@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lai@#,@#49331@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lan@#,@#49334@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lang@#,@#49349@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lao@#,@#49356@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#le@#,@#49365@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lei@#,@#49367@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#leng@#,@#49378@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#li@#,@#49381@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lia@#,@#49577@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lian@#,@#49578@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#liang@#,@#49592@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#liao@#,@#49603@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lie@#,@#49616@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lin@#,@#49621@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ling@#,@#49633@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#liu@#,@#49647@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#long@#,@#49658@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lou@#,@#49829@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lu@#,@#49835@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lv@#,@#49855@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#luan@#,@#49869@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lue@#,@#49875@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#lun@#,@#49877@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#luo@#,@#49884@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ma@#,@#49896@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mai@#,@#49905@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#man@#,@#49911@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mang@#,@#50082@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mao@#,@#50088@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#me@#,@#50100@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mei@#,@#50101@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#men@#,@#50117@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#meng@#,@#50120@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mi@#,@#50128@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mian@#,@#50142@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#miao@#,@#50151@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mie@#,@#50159@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#min@#,@#50161@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ming@#,@#50167@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#miu@#,@#50173@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mo@#,@#50174@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mou@#,@#50353@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#mu@#,@#50356@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#na@#,@#50371@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nai@#,@#50378@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nan@#,@#50383@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nang@#,@#50386@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nao@#,@#50387@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ne@#,@#50392@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nei@#,@#50393@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nen@#,@#50395@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#neng@#,@#50396@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ni@#,@#50397@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nian@#,@#50408@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#niang@#,@#50415@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#niao@#,@#50417@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nie@#,@#50419@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nin@#,@#50426@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ning@#,@#50427@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#niu@#,@#50595@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nong@#,@#50599@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nu@#,@#50603@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nv@#,@#50606@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nuan@#,@#50607@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nue@#,@#50608@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#nuo@#,@#50610@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#o@#,@#50614@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ou@#,@#50615@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pa@#,@#50622@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pai@#,@#50628@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pan@#,@#50634@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pang@#,@#50642@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pao@#,@#50647@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pei@#,@#50654@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pen@#,@#50663@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#peng@#,@#50665@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pi@#,@#50679@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pian@#,@#50858@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#piao@#,@#50862@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pie@#,@#50866@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pin@#,@#50868@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ping@#,@#50873@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#po@#,@#50882@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#pu@#,@#50891@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qi@#,@#50906@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qia@#,@#50942@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qian@#,@#51107@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qiang@#,@#51129@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qiao@#,@#51137@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qie@#,@#51152@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qin@#,@#51157@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qing@#,@#51168@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qiong@#,@#51181@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qiu@#,@#51183@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qu@#,@#51191@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#quan@#,@#51366@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#que@#,@#51377@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#qun@#,@#51385@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ran@#,@#51387@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#rang@#,@#51391@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#rao@#,@#51396@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#re@#,@#51399@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ren@#,@#51401@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#reng@#,@#51411@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ri@#,@#51413@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#rong@#,@#51414@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#rou@#,@#51424@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ru@#,@#51427@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ruan@#,@#51437@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#rui@#,@#51439@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#run@#,@#51442@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ruo@#,@#51444@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sa@#,@#51446@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sai@#,@#51449@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#san@#,@#51453@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sang@#,@#51619@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sao@#,@#51622@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#se@#,@#51626@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sen@#,@#51629@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#seng@#,@#51630@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sha@#,@#51631@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shai@#,@#51640@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shan@#,@#51642@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shang@#,@#51658@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shao@#,@#51666@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#she@#,@#51677@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shen@#,@#51689@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sheng@#,@#51705@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shi@#,@#51878@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shou@#,@#51925@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shu@#,@#51935@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shua@#,@#52130@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shuai@#,@#52132@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shuan@#,@#52136@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shuang@#,@#52138@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shui@#,@#52141@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shun@#,@#52145@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#shuo@#,@#52149@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#si@#,@#52153@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#song@#,@#52169@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sou@#,@#52177@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#su@#,@#52180@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#suan@#,@#52193@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sui@#,@#52196@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#sun@#,@#52207@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#suo@#,@#52210@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ta@#,@#52218@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tai@#,@#52389@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tan@#,@#52398@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tang@#,@#52416@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tao@#,@#52429@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#te@#,@#52440@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#teng@#,@#52441@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ti@#,@#52445@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tian@#,@#52460@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tiao@#,@#52468@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tie@#,@#52473@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ting@#,@#52476@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tong@#,@#52648@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tou@#,@#52661@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tu@#,@#52665@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tuan@#,@#52676@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tui@#,@#52678@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tun@#,@#52684@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#tuo@#,@#52687@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wa@#,@#52698@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wai@#,@#52705@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wan@#,@#52707@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wang@#,@#52724@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wei@#,@#52734@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wen@#,@#52929@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#weng@#,@#52939@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wo@#,@#52942@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#wu@#,@#52951@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xi@#,@#52980@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xia@#,@#53177@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xian@#,@#53190@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xiang@#,@#53216@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xiao@#,@#53236@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xie@#,@#53416@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xin@#,@#53437@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xing@#,@#53447@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xiong@#,@#53462@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xiu@#,@#53469@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xu@#,@#53478@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xuan@#,@#53497@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xue@#,@#53669@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#xun@#,@#53675@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ya@#,@#53689@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yan@#,@#53705@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yang@#,@#53738@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yao@#,@#53755@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ye@#,@#53932@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yi@#,@#53947@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yin@#,@#54000@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ying@#,@#54178@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yo@#,@#54196@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yong@#,@#54197@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#you@#,@#54212@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yu@#,@#54233@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yuan@#,@#54439@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yue@#,@#54459@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#yun@#,@#54469@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#za@#,@#54481@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zai@#,@#54484@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zan@#,@#54491@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zang@#,@#54495@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zao@#,@#54498@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#ze@#,@#54512@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zei@#,@#54516@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zen@#,@#54517@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zeng@#,@#54518@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zha@#,@#54522@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhai@#,@#54698@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhan@#,@#54704@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhang@#,@#54721@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhao@#,@#54736@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhe@#,@#54746@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhen@#,@#54756@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zheng@#,@#54772@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhi@#,@#54949@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhong@#,@#54992@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhou@#,@#55003@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhu@#,@#55017@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhua@#,@#55205@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhuai@#,@#55207@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhuan@#,@#55208@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhuang@#,@#55214@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhui@#,@#55221@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhun@#,@#55227@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zhuo@#,@#55229@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zi@#,@#55240@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zong@#,@#55255@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zou@#,@#55262@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zu@#,@#55266@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zuan@#,@#55274@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zui@#,@#55276@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zun@#,@#55280@#)/INSERT INTO T_PINYIN(HZPY,NUM) VALUES(@#zuo@#,@#55282@#)/
接下来我们要编写一个函数来实现获取汉字拼音编码。在编写这个函数的过程中我发现了oracle处理中英文混合字符串的bug，因此函数中采用在任何字符串前添加一个★号来强制oracle把此字符串当作双字节来处理。代码如下：
create or replace function GetPinYin(Keyword in varchar2) return varchar2 isbeginDECLARE i int; j int; PinYin varchar2(500); Temp varchar2(10); TempStr varchar2(2);begin i:=1; j:=Length(@#★@#||Keyword); PinYin:=@#@#; While i<=j LOOP TempStr:=substr(@#★@#||KeyWord,i,1); select HZPY INTO Temp from BJXKS.t_Pinyin Where Num=(select max(num) from BJXKS.t_Pinyin Where Num<=ASCII(TempStr)); Temp:=Replace(Temp,@#*@#,TempStr); Temp:=Replace(Temp,@#★@#,@#@#); PinYin:=PinYin||Temp; i:=i+1; End loop; return(PinYin);end;end GetPinYin;
好了，现在可以用这个函数来实现汉字的同音查询了。如查询表table1中字段A中读音和“啊”一样的记录，SQL语句可以这样写：
select * from table1 where getpinyin(A) like @#%a%@#
以上方法仅供参考，如有不妥请批评指正，谢谢！
