MYSQL网页设计【原创】oracle数据库使用中完成汉字“...

MySQL采用双重授权(DualLicensed)，它们是GPL和MySQLAB制定的商业许可协议。oracle|汉字|数据|数据库|原创
要完成“同音”查询固然要先失掉汉字的汉语拼音了，在网上到处能够找到ASP的汉字转拼音的代码，如以下代码：

<%Setd=CreateObject("Scripting.Dictionary")d.add"a",-20319d.add"ai",-20317d.add"an",-20304d.add"ang",-20295d.add"ao",-20292d.add"ba",-20283d.add"bai",-20265d.add"ban",-20257d.add"bang",-20242d.add"bao",-20230d.add"bei",-20051d.add"ben",-20036d.add"beng",-20032d.add"bi",-20026d.add"bian",-20002d.add"biao",-19990d.add"bie",-19986d.add"bin",-19982d.add"bing",-19976d.add"bo",-19805d.add"bu",-19784d.add"ca",-19775d.add"cai",-19774d.add"can",-19763d.add"cang",-19756d.add"cao",-19751d.add"ce",-19746d.add"ceng",-19741d.add"cha",-19739d.add"chai",-19728d.add"chan",-19725d.add"chang",-19715d.add"chao",-19540d.add"che",-19531d.add"chen",-19525d.add"cheng",-19515d.add"chi",-19500d.add"chong",-19484d.add"chou",-19479d.add"chu",-19467d.add"chuai",-19289d.add"chuan",-19288d.add"chuang",-19281d.add"chui",-19275d.add"chun",-19270d.add"chuo",-19263d.add"ci",-19261d.add"cong",-19249d.add"cou",-19243d.add"cu",-19242d.add"cuan",-19238d.add"cui",-19235d.add"cun",-19227d.add"cuo",-19224d.add"da",-19218d.add"dai",-19212d.add"dan",-19038d.add"dang",-19023d.add"dao",-19018d.add"de",-19006d.add"deng",-19003d.add"di",-18996d.add"dian",-18977d.add"diao",-18961d.add"die",-18952d.add"ding",-18783d.add"diu",-18774d.add"dong",-18773d.add"dou",-18763d.add"du",-18756d.add"duan",-18741d.add"dui",-18735d.add"dun",-18731d.add"duo",-18722d.add"e",-18710d.add"en",-18697d.add"er",-18696d.add"fa",-18526d.add"fan",-18518d.add"fang",-18501d.add"fei",-18490d.add"fen",-18478d.add"feng",-18463d.add"fo",-18448d.add"fou",-18447d.add"fu",-18446d.add"ga",-18239d.add"gai",-18237d.add"gan",-18231d.add"gang",-18220d.add"gao",-18211d.add"ge",-18201d.add"gei",-18184d.add"gen",-18183d.add"geng",-18181d.add"gong",-18012d.add"gou",-17997d.add"gu",-17988d.add"gua",-17970d.add"guai",-17964d.add"guan",-17961d.add"guang",-17950d.add"gui",-17947d.add"gun",-17931d.add"guo",-17928d.add"ha",-17922d.add"hai",-17759d.add"han",-17752d.add"hang",-17733d.add"hao",-17730d.add"he",-17721d.add"hei",-17703d.add"hen",-17701d.add"heng",-17697d.add"hong",-17692d.add"hou",-17683d.add"hu",-17676d.add"hua",-17496d.add"huai",-17487d.add"huan",-17482d.add"huang",-17468d.add"hui",-17454d.add"hun",-17433d.add"huo",-17427d.add"ji",-17417d.add"jia",-17202d.add"jian",-17185d.add"jiang",-16983d.add"jiao",-16970d.add"jie",-16942d.add"jin",-16915d.add"jing",-16733d.add"jiong",-16708d.add"jiu",-16706d.add"ju",-16689d.add"juan",-16664d.add"jue",-16657d.add"jun",-16647d.add"ka",-16474d.add"kai",-16470d.add"kan",-16465d.add"kang",-16459d.add"kao",-16452d.add"ke",-16448d.add"ken",-16433d.add"keng",-16429d.add"kong",-16427d.add"kou",-16423d.add"ku",-16419d.add"kua",-16412d.add"kuai",-16407d.add"kuan",-16403d.add"kuang",-16401d.add"kui",-16393d.add"kun",-16220d.add"kuo",-16216d.add"la",-16212d.add"lai",-16205d.add"lan",-16202d.add"lang",-16187d.add"lao",-16180d.add"le",-16171d.add"lei",-16169d.add"leng",-16158d.add"li",-16155d.add"lia",-15959d.add"lian",-15958d.add"liang",-15944d.add"liao",-15933d.add"lie",-15920d.add"lin",-15915d.add"ling",-15903d.add"liu",-15889d.add"long",-15878d.add"lou",-15707d.add"lu",-15701d.add"lv",-15681d.add"luan",-15667d.add"lue",-15661d.add"lun",-15659d.add"luo",-15652d.add"ma",-15640d.add"mai",-15631d.add"man",-15625d.add"mang",-15454d.add"mao",-15448d.add"me",-15436d.add"mei",-15435d.add"men",-15419d.add"meng",-15416d.add"mi",-15408d.add"mian",-15394d.add"miao",-15385d.add"mie",-15377d.add"min",-15375d.add"ming",-15369d.add"miu",-15363d.add"mo",-15362d.add"mou",-15183d.add"mu",-15180d.add"na",-15165d.add"nai",-15158d.add"nan",-15153d.add"nang",-15150d.add"nao",-15149d.add"ne",-15144d.add"nei",-15143d.add"nen",-15141d.add"neng",-15140d.add"ni",-15139d.add"nian",-15128d.add"niang",-15121d.add"niao",-15119d.add"nie",-15117d.add"nin",-15110d.add"ning",-15109d.add"niu",-14941d.add"nong",-14937d.add"nu",-14933d.add"nv",-14930d.add"nuan",-14929d.add"nue",-14928d.add"nuo",-14926d.add"o",-14922d.add"ou",-14921d.add"pa",-14914d.add"pai",-14908d.add"pan",-14902d.add"pang",-14894d.add"pao",-14889d.add"pei",-14882d.add"pen",-14873d.add"peng",-14871d.add"pi",-14857d.add"pian",-14678d.add"piao",-14674d.add"pie",-14670d.add"pin",-14668d.add"ping",-14663d.add"po",-14654d.add"pu",-14645d.add"qi",-14630d.add"qia",-14594d.add"qian",-14429d.add"qiang",-14407d.add"qiao",-14399d.add"qie",-14384d.add"qin",-14379d.add"qing",-14368d.add"qiong",-14355d.add"qiu",-14353d.add"qu",-14345d.add"quan",-14170d.add"que",-14159d.add"qun",-14151d.add"ran",-14149d.add"rang",-14145d.add"rao",-14140d.add"re",-14137d.add"ren",-14135d.add"reng",-14125d.add"ri",-14123d.add"rong",-14122d.add"rou",-14112d.add"ru",-14109d.add"ruan",-14099d.add"rui",-14097d.add"run",-14094d.add"ruo",-14092d.add"sa",-14090d.add"sai",-14087d.add"san",-14083d.add"sang",-13917d.add"sao",-13914d.add"se",-13910d.add"sen",-13907d.add"seng",-13906d.add"sha",-13905d.add"shai",-13896d.add"shan",-13894d.add"shang",-13878d.add"shao",-13870d.add"she",-13859d.add"shen",-13847d.add"sheng",-13831d.add"shi",-13658d.add"shou",-13611d.add"shu",-13601d.add"shua",-13406d.add"shuai",-13404d.add"shuan",-13400d.add"shuang",-13398d.add"shui",-13395d.add"shun",-13391d.add"shuo",-13387d.add"si",-13383d.add"song",-13367d.add"sou",-13359d.add"su",-13356d.add"suan",-13343d.add"sui",-13340d.add"sun",-13329d.add"suo",-13326d.add"ta",-13318d.add"tai",-13147d.add"tan",-13138d.add"tang",-13120d.add"tao",-13107d.add"te",-13096d.add"teng",-13095d.add"ti",-13091d.add"tian",-13076d.add"tiao",-13068d.add"tie",-13063d.add"ting",-13060d.add"tong",-12888d.add"tou",-12875d.add"tu",-12871d.add"tuan",-12860d.add"tui",-12858d.add"tun",-12852d.add"tuo",-12849d.add"wa",-12838d.add"wai",-12831d.add"wan",-12829d.add"wang",-12812d.add"wei",-12802d.add"wen",-12607d.add"weng",-12597d.add"wo",-12594d.add"wu",-12585d.add"xi",-12556d.add"xia",-12359d.add"xian",-12346d.add"xiang",-12320d.add"xiao",-12300d.add"xie",-12120d.add"xin",-12099d.add"xing",-12089d.add"xiong",-12074d.add"xiu",-12067d.add"xu",-12058d.add"xuan",-12039d.add"xue",-11867d.add"xun",-11861d.add"ya",-11847d.add"yan",-11831d.add"yang",-11798d.add"yao",-11781d.add"ye",-11604d.add"yi",-11589d.add"yin",-11536d.add"ying",-11358d.add"yo",-11340d.add"yong",-11339d.add"you",-11324d.add"yu",-11303d.add"yuan",-11097d.add"yue",-11077d.add"yun",-11067d.add"za",-11055d.add"zai",-11052d.add"zan",-11045d.add"zang",-11041d.add"zao",-11038d.add"ze",-11024d.add"zei",-11020d.add"zen",-11019d.add"zeng",-11018d.add"zha",-11014d.add"zhai",-10838d.add"zhan",-10832d.add"zhang",-10815d.add"zhao",-10800d.add"zhe",-10790d.add"zhen",-10780d.add"zheng",-10764d.add"zhi",-10587d.add"zhong",-10544d.add"zhou",-10533d.add"zhu",-10519d.add"zhua",-10331d.add"zhuai",-10329d.add"zhuan",-10328d.add"zhuang",-10322d.add"zhui",-10315d.add"zhun",-10309d.add"zhuo",-10307d.add"zi",-10296d.add"zong",-10281d.add"zou",-10274d.add"zu",-10270d.add"zuan",-10262d.add"zui",-10260d.add"zun",-10256d.add"zuo",-10254functiong(num)ifnum>0andnum<160theng=chr(num)elseifnum<-20319ornum>-10247theng=""elsea=d.Itemsb=d.keysfori=d.count-1to0step-1ifa(i)<=numthenexitfornextg=b(i)endifendifendfunctionfunctionc(str)c=""fori=1tolen(str)c=c&g(asc(mid(str,i,1)))nextendfunctionresponse.writec(request("hz"))%><formmethod=post>请在此处输出中文：<inputname=hz></form>

以上代码的道理非常复杂，这里我未几说了，上面我们把下面的码表导进oracle表中，不外要注重一下，oracle中内置的ASCII()函数于VB中的ASC()函数的前往值局限分歧，我们必要加上65536得出的才是oracle中汉字的ascii码，如：VB中ASC("啊")=-20319，在oracle中ASCII("啊")=-20319+65536=45217。以下是天生oracle码表的剧本。

/*TABLENAME:T_PINYIN*//*CREATETIME:2005-2-190:19:26*/

CREATETABLEBJXKS."T_PINYIN"(HZPYVARCHAR(10),NUMINT)/

INSERTINTOT_PINYIN(HZPY,NUM)VALUES(★,41455)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(*,255)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(*,1)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(a,45217)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ai,45219)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(an,45232)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ang,45241)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ao,45244)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ba,45253)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bai,45271)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ban,45279)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bang,45294)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bao,45306)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bei,45485)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ben,45500)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(beng,45504)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bi,45510)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bian,45534)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(biao,45546)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bie,45550)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bin,45554)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bing,45560)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bo,45731)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(bu,45752)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ca,45761)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cai,45762)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(can,45773)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cang,45780)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cao,45785)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ce,45790)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ceng,45795)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cha,45797)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chai,45808)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chan,45811)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chang,45821)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chao,45996)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(che,46005)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chen,46011)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cheng,46021)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chi,46036)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chong,46052)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chou,46057)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chu,46069)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chuai,46247)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chuan,46248)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chuang,46255)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chui,46261)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chun,46266)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(chuo,46273)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ci,46275)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cong,46287)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cou,46293)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cu,46294)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cuan,46298)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cui,46301)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cun,46309)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(cuo,46312)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(da,46318)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dai,46324)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dan,46498)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dang,46513)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dao,46518)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(de,46530)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(deng,46533)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(di,46540)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dian,46559)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(diao,46575)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(die,46584)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ding,46753)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(diu,46762)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dong,46763)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dou,46773)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(du,46780)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(duan,46795)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dui,46801)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(dun,46805)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(duo,46814)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(e,46826)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(en,46839)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(er,46840)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fa,47010)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fan,47018)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fang,47035)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fei,47046)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fen,47058)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(feng,47073)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fo,47088)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fou,47089)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(fu,47090)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ga,47297)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gai,47299)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gan,47305)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gang,47316)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gao,47325)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ge,47335)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gei,47352)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gen,47353)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(geng,47355)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gong,47524)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gou,47539)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gu,47548)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gua,47566)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(guai,47572)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(guan,47575)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(guang,47586)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gui,47589)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(gun,47605)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(guo,47608)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ha,47614)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hai,47777)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(han,47784)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hang,47803)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hao,47806)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(he,47815)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hei,47833)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hen,47835)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(heng,47839)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hong,47844)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hou,47853)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hu,47860)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hua,48040)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(huai,48049)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(huan,48054)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(huang,48068)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hui,48082)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(hun,48103)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(huo,48109)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ji,48119)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jia,48334)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jian,48351)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jiang,48553)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jiao,48566)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jie,48594)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jin,48621)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jing,48803)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jiong,48828)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jiu,48830)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ju,48847)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(juan,48872)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jue,48879)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(jun,48889)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ka,49062)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kai,49066)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kan,49071)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kang,49077)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kao,49084)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ke,49088)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ken,49103)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(keng,49107)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kong,49109)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kou,49113)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ku,49117)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kua,49124)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kuai,49129)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kuan,49133)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kuang,49135)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kui,49143)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kun,49316)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(kuo,49320)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(la,49324)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lai,49331)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lan,49334)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lang,49349)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lao,49356)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(le,49365)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lei,49367)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(leng,49378)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(li,49381)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lia,49577)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lian,49578)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(liang,49592)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(liao,49603)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lie,49616)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lin,49621)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ling,49633)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(liu,49647)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(long,49658)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lou,49829)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lu,49835)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lv,49855)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(luan,49869)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lue,49875)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(lun,49877)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(luo,49884)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ma,49896)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mai,49905)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(man,49911)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mang,50082)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mao,50088)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(me,50100)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mei,50101)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(men,50117)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(meng,50120)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mi,50128)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mian,50142)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(miao,50151)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mie,50159)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(min,50161)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ming,50167)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(miu,50173)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mo,50174)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mou,50353)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(mu,50356)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(na,50371)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nai,50378)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nan,50383)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nang,50386)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nao,50387)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ne,50392)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nei,50393)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nen,50395)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(neng,50396)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ni,50397)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nian,50408)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(niang,50415)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(niao,50417)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nie,50419)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nin,50426)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ning,50427)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(niu,50595)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nong,50599)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nu,50603)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nv,50606)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nuan,50607)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nue,50608)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(nuo,50610)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(o,50614)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ou,50615)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pa,50622)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pai,50628)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pan,50634)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pang,50642)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pao,50647)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pei,50654)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pen,50663)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(peng,50665)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pi,50679)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pian,50858)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(piao,50862)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pie,50866)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pin,50868)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ping,50873)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(po,50882)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(pu,50891)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qi,50906)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qia,50942)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qian,51107)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qiang,51129)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qiao,51137)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qie,51152)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qin,51157)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qing,51168)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qiong,51181)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qiu,51183)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qu,51191)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(quan,51366)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(que,51377)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(qun,51385)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ran,51387)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(rang,51391)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(rao,51396)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(re,51399)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ren,51401)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(reng,51411)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ri,51413)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(rong,51414)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(rou,51424)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ru,51427)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ruan,51437)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(rui,51439)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(run,51442)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ruo,51444)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sa,51446)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sai,51449)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(san,51453)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sang,51619)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sao,51622)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(se,51626)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sen,51629)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(seng,51630)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sha,51631)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shai,51640)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shan,51642)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shang,51658)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shao,51666)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(she,51677)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shen,51689)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sheng,51705)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shi,51878)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shou,51925)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shu,51935)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shua,52130)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shuai,52132)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shuan,52136)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shuang,52138)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shui,52141)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shun,52145)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(shuo,52149)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(si,52153)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(song,52169)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sou,52177)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(su,52180)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(suan,52193)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sui,52196)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(sun,52207)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(suo,52210)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ta,52218)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tai,52389)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tan,52398)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tang,52416)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tao,52429)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(te,52440)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(teng,52441)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ti,52445)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tian,52460)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tiao,52468)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tie,52473)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ting,52476)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tong,52648)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tou,52661)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tu,52665)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tuan,52676)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tui,52678)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tun,52684)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(tuo,52687)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wa,52698)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wai,52705)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wan,52707)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wang,52724)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wei,52734)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wen,52929)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(weng,52939)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wo,52942)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(wu,52951)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xi,52980)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xia,53177)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xian,53190)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xiang,53216)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xiao,53236)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xie,53416)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xin,53437)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xing,53447)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xiong,53462)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xiu,53469)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xu,53478)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xuan,53497)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xue,53669)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(xun,53675)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ya,53689)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yan,53705)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yang,53738)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yao,53755)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ye,53932)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yi,53947)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yin,54000)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ying,54178)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yo,54196)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yong,54197)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(you,54212)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yu,54233)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yuan,54439)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yue,54459)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(yun,54469)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(za,54481)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zai,54484)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zan,54491)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zang,54495)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zao,54498)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(ze,54512)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zei,54516)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zen,54517)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zeng,54518)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zha,54522)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhai,54698)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhan,54704)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhang,54721)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhao,54736)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhe,54746)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhen,54756)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zheng,54772)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhi,54949)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhong,54992)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhou,55003)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhu,55017)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhua,55205)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhuai,55207)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhuan,55208)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhuang,55214)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhui,55221)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhun,55227)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zhuo,55229)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zi,55240)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zong,55255)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zou,55262)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zu,55266)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zuan,55274)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zui,55276)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zun,55280)/INSERTINTOT_PINYIN(HZPY,NUM)VALUES(zuo,55282)/

接上去我们要编写一个函数来完成猎取汉字拼音编码。在编写这个函数的过程当中我发明了oracle处置中英文夹杂字符串的bug，因而函数中接纳在任何字符串前增加一个★号来强迫oracle把此字符串看成双字节来处置。代码以下：

createorreplacefunctionGetPinYin(Keywordinvarchar2)returnvarchar2isbeginDECLAREiint;jint;PinYinvarchar2(500);Tempvarchar2(10);TempStrvarchar2(2);begini:=1;j:=Length(★||Keyword);PinYin:=;Whilei<=jLOOPTempStr:=substr(★||KeyWord,i,1);selectHZPYINTOTempfromBJXKS.t_PinyinWhereNum=(selectmax(num)fromBJXKS.t_PinyinWhereNum<=ASCII(TempStr));Temp:=Replace(Temp,*,TempStr);Temp:=Replace(Temp,★,);PinYin:=PinYin||Temp;i:=i+1;Endloop;return(PinYin);end;endGetPinYin;

好了，如今能够用这个函数来完成汉字的同音查询了。如查询表table1中字段A中读音和“啊”一样的纪录，SQL语句能够如许写：

select*fromtable1wheregetpinyin(A)like%a%

以上办法仅供参考，若有不当请品评斧正，感谢！
”由于MySQL已经是一个运行了众多知名Web2.0网站的数据，包括Craigslist、Digg、Wikipedia和Google等，或许我们可以说每一个Web2.0公司实质上是一个使用MySQL数据库的公司。

语句级快照和事务级快照终于为SQLServer的并发性能带来了突破。个人感觉语句级快照大家应该应用。事务级快照，如果是高并发系统还要慎用。如果一个用户总是被提示修改不成功要求重试时，会杀人的！

比如，MicrosoftSQLServer2008的某一个版本可以满足现在的这个业务的需要，而且价格还比Oracle11g要便宜，那么这一产品就是适合的。

原来的计算字段其实和虚拟字段很像。只是管理方面好了而已，性能方面提高不多。但是SQL2005提供了计算字段的持久化，这就提高了查询的性能，但是会加重insert和update的负担。OLTP慎用。OLAP可以大规模使用。

需要注意的一点，也是我使用过程中发现的一个问题。在建立function->schema->table后，如果在现有的分区表上建立没有显式声明的聚集索引时，分区表会自动变为非分区表。这一点很让我纳闷。

其中最有名的应该是row_number了。这个终于解决了用临时表生成序列号的历史，而且SQLServer2005的row_number比Oracle的更先进。因为它把Orderby集成到了一起，不用像Oracle那样还要用子查询进行封装。

如果处理少量数据,比如几百条记录的数据,我不知道这两种情况哪个效率更高,如果处理大量数据呢?比如有表中有20万条记录.

一直以来个人感觉SQLServer的优化器要比Oracle的聪明。SQL2005的更是比2k聪明了不少。（有次作试验发现有的语句在200万级时还比50万级的相同语句要快show_text的一些提示没有找到解释。一直在奇怪。）

SP4包括用于以下SQLServer2000组件的程序包：Database组件（下载文件：SQL2000-KB884525-SP4-x86.EXE）更新SQLServer2000的32位Database组件，包括数据库引擎、复制、客户端连接组件及工具。有关其他信息，请参阅ReadmeSql2k32Sp4.htm。AnalysisServices组件（下载文件：SQL2000.AS-KB884525-SP4-x86.EXE）更新SQLServer2000的32位AnalysisServices。