[Original] Oracle Database Application Implementation Chinese Characters "Sound" inquiry

xiaoxiao2021-03-06 14

To achieve the "homonym" query, of course, you must first get the Chinese characters of Chinese characters, you can find the code of the ASP's Chinese characters to the Pinyin, such as the following code:

<% 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", - 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 "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 " ", - 19484 d.add" chou ", - 19479 D.Add" Chu ", - 19467 D.Add" Chuai ", - 19 289 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 " ", - 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 ", - 17759 d.add" hai ", - 17752 D .add "hang", - 17733 d.add "hao"

, -17730 d.add "HE", - 177703 D.Add "HEN", - 17697 D.Add "HONG", - 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" kua NG ", - 16401 D.Add" KUI ", - 16393 D.Add" KUN ", - 16220 D.Add" Kuo ", - 16212 D.Add" la ", - 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", - 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", - 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 " ", - 15377 d.add" min ", - 15375 d.add" ming ", - 15369 d.add" miu ", - 15362 d.add" mou ", - 15183 D. ADD "MU", - 15180 D.Add "NA", - 15158 D.ADD "Nai", - 15153 D.Add "NAN", - 15150 D.ADD "NAO ", -15149 D.Add" Ne ", - 15144 D.Add" Nei ", - 15143 D.Add" Nen ", - 15141 D.ADD" NENG ", - 1514 0 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" NON ", - 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 " "Qiu", - 14353 D.Add "quan", - 14159 D.Add "QUE", - 14159 D.Add "QUN", - 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 "shuan", - 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 "

"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", - 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", - 10519 d.add "zhua", - 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 the 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 (STR (STR (STR, I, 1))) NEXT End Function Response.write C (Request ("Hz"))% >

Please enter Chinese here: The principle of the above code is very simple, here I don't say much, let's import the above code table into the Oracle table, However, pay attention to the Return value of the ASCII () function in Oracle in the VB, the return value of the ASC () function we need to add 65536 is the ASCII code of the Chinese characters in Oracle, such as: VB ASC ( "Ah") = - 20319, in Oracle ASCII ("ah") = - 20319 65536 = 45217. The following is a script that generates an Oracle code table.

/ * Table name: t_preate 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_P INYIN (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) VALU ES ('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', '4730 5 ') / 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 ('HE NG ',' 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) Value S ('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 ('L ENG ',' 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) VAL UES ('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 ('xin G ',' 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 (H ZPY, 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') / Next We want to write a function to achieve Chinese characters pinyin code. In the process of writing this function, I found the bug of Oracle handling in English-English mixing strings, so adding a ★ bouting before any string is used in any string to process this string as a double byte. code show as below:

Create Or Replace Function Getpinyin (Keyword In VARCHAR2) RETURN VARCHAR2 ISBEGINDECLARE I 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; end; end pinsyin;

Ok, you can now use this function to realize the homonym of Chinese characters. If you read the sounds in the field A in the query table Table1, the SQL statement can be written like this:

Select * from table1 where getpinyin (a) Like '% a%'

The above methods are for reference only. If there is any case, please criticize, thank you!

转载请注明原文地址:https://www.9cbs.com/read-50170.html

9cbs

New Post(0)