From: Martin Gainty Date: September 21 2009 8:06pm Subject: RE: incremental name search? List-Archive: http://lists.mysql.com/mysql/218781 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_25d74fb2-d7b9-462f-a3d1-5c685123764b_" --_25d74fb2-d7b9-462f-a3d1-5c685123764b_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable agreed better to know which languages you'll support and load in the correct chars= et up front retro-fitting an existing DB to another charset can be time consuming and e= rror-prone e.g. # Convert all tables to UTF-8 with binary collation and reset all char colu= mns to correct width ALTER TABLE user MODIFY Host char(60) NOT NULL default ''=2C MODIFY User char(16) NOT NULL default ''=2C ENGINE=3DMyISAM=2C CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin=3B # much better: USE Database SET character_set_client =3D utf8=3B CREATE Martin Gainty=20 ______________________________________________=20 Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit= =E9 =20 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes= pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat= isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e= ou la copie de ceci est interdite. Ce message sert =E0 l'information seule= ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d= onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation= =2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni= . > From: jschwartz@stripped > To: mdykman@stripped=3B mspreitz@stripped > CC: mysql@stripped > Subject: RE: incremental name search? > Date: Mon=2C 21 Sep 2009 15:47:20 -0400 >=20 > SoundEx doesn't do much for names=2C or non-English words for that matter= . >=20 > Although you could use AJAX to handle the web part of this=2C I can't ima= gine it=20 > being able to handle much of a load. I think you'll beat the system to de= ath=2C=20 > to little avail. >=20 > Regards=2C >=20 > Jerry Schwartz > The Infoshop by Global Information Incorporated > 195 Farmington Ave. > Farmington=2C CT 06032 >=20 > 860.674.8796 / FAX: 860.674.8341 >=20 > www.the-infoshop.com >=20 > >-----Original Message----- > >From: Michael Dykman [mailto:mdykman@stripped] > >Sent: Monday=2C September 21=2C 2009 12:21 PM > >To: Mike Spreitzer > >Cc: mysql@stripped > >Subject: Re: incremental name search? > > > >Perhaps this could help you out.. > > > >http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_so= undex > > > > - michael dykman > > > >On Mon=2C Sep 21=2C 2009 at 11:51 AM=2C Mike Spreitzer wrote: > >> Suppose I have a table of a few thousand people=2C with a FirstName fi= eld > >> and a LastName field. Sadly=2C my people are not so regular. Some na= mes > >> have three parts (e.g.=2C due to marriage) crammed into the two fields > >> ("Hillary Rodham Clinton"). Some even have titles ("Dir=2C gastroent. > >> dept.=2C Fubar hosp. OurTown") wedged in there. I want to make a web = app > >> that searches this table incrementally as I type into a web page in my > >> browser. I am thinking I will have to do something like continuously > >> display the top 10 matches to what I have typed so far. Of course=2C = when I > >> am typing I do not know exactly what is in the database. I generally = know > >> only some of the parts of the name when I am typing (e.g.=2C I am look= ing up > >> "Mary Jones" without knowing whether Jones is her maiden name). Somet= imes > >> I am even typing something that is a spelled a bit wrong ("Schiller" v= s. > >> "Shiller") or variantly ("Lizzie" vs. "Elizabeth"). This seems pretty= far > >> from what MySQL can do directly. I know about "LIKE" matching. I kno= w > >> the wider SQL community has something called "soundex"=2C but I have n= ot yet > >> found it in MySQL. I have a hard time imagining what will help me wit= h > >> variants on a name. I do not see any easy way to find the "top 10" > >> matches. Am I missing anything that can help me here? > >> > >> Thanks in advance! > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail.= com > >> > >> > > > > > > > >-- > > - michael dykman > > - mdykman@stripped > > > >Don't worry about people stealing your ideas. If they're any good=2C > >you'll have to ram them down their throats! > > > > Howard Aiken > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/mysql?unsub=3Djschwartz@the- > >infoshop.com >=20 >=20 >=20 >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 _________________________________________________________________ Ready for Fall shows? Use Bing to find helpful ratings and reviews on digit= al tv's. http://www.bing.com/shopping/search?q=3Ddigital+tv's&form=3DMSHNCB&publ=3DW= LHMTAG&crea=3DTEXT_MSHNCB_Vertical_Shopping_DigitalTVs_1x1= --_25d74fb2-d7b9-462f-a3d1-5c685123764b_--