分享
 
 
 

【原创】oracle数据库应用中实现汉字“同音”查询

王朝oracle·作者佚名  2006-05-27
窄屏简体版  字體: |||超大  

要实现“同音”查询当然要先得到汉字的汉语拼音了,在网上随处可以找到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 is

begin

DECLARE

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%'

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

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有