【原创】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%@#

以上方法仅供参考,如有不妥请批评指正,谢谢!

原文转自:http://www.ltesting.net