List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:September 21 2009 8:06pm
Subject:RE: incremental name search?
View as plain text  
agreed

better to know which languages you'll support and load in the correct charset up front
retro-fitting an existing DB to another charset can be time consuming and error-prone e.g.

# Convert all tables to UTF-8 with binary collation and reset all char columns to correct
width
ALTER TABLE user
  MODIFY Host char(60) NOT NULL default '',
  MODIFY User char(16) NOT NULL default '',
  ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

# much better:
USE Database
SET character_set_client = utf8;
CREATE

Martin Gainty 
______________________________________________ 
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so
bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer
Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous
n'êtes pas le destinataire prévu, nous te demandons avec bonté que
pour satisfaire informez l'expéditeur. N'importe quelle diffusion non
autorisée ou la copie de ceci est interdite. Ce message sert à
l'information seulement et n'aura pas n'importe quel effet légalement obligatoire.
Étant donné que les email peuvent facilement être sujets à la
manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu
fourni.




> From: jschwartz@stripped
> To: mdykman@stripped; mspreitz@stripped
> CC: mysql@stripped
> Subject: RE: incremental name search?
> Date: Mon, 21 Sep 2009 15:47:20 -0400
> 
> SoundEx doesn't do much for names, or non-English words for that matter.
> 
> Although you could use AJAX to handle the web part of this, I can't imagine it 
> being able to handle much of a load. I think you'll beat the system to death, 
> to little avail.
> 
> Regards,
> 
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
> 
> 860.674.8796 / FAX: 860.674.8341
> 
> www.the-infoshop.com
> 
> >-----Original Message-----
> >From: Michael Dykman [mailto:mdykman@stripped]
> >Sent: Monday, September 21, 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_soundex
> >
> > - michael dykman
> >
> >On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer <mspreitz@stripped>
> wrote:
> >> Suppose I have a table of a few thousand people, with a FirstName field
> >> and a LastName field.  Sadly, my people are not so regular.  Some names
> >> have three parts (e.g., due to marriage) crammed into the two fields
> >> ("Hillary Rodham Clinton").  Some even have titles ("Dir, gastroent.
> >> dept., 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, 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., I am looking up
> >> "Mary Jones" without knowing whether Jones is her maiden name).  Sometimes
> >> I am even typing something that is a spelled a bit wrong ("Schiller" vs.
> >> "Shiller") or variantly ("Lizzie" vs. "Elizabeth").  This seems pretty far
> >> from what MySQL can do directly.  I know about "LIKE" matching.  I know
> >> the wider SQL community has something called "soundex", but I have not yet
> >> found it in MySQL.  I have a hard time imagining what will help me with
> >> 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=1
> >>
> >>
> >
> >
> >
> >--
> > - michael dykman
> > - mdykman@stripped
> >
> >Don't worry about people stealing your ideas. If they're any good,
> >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=1
> >infoshop.com
> 
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

_________________________________________________________________
Ready for Fall shows? Use Bing to find helpful ratings and reviews on digital tv's.
http://www.bing.com/shopping/search?q=digital+tv's&form=MSHNCB&publ=WLHMTAG&crea=TEXT_MSHNCB_Vertical_Shopping_DigitalTVs_1x1
Thread
incremental name search?Mike Spreitzer21 Sep
  • Re: incremental name search?Michael Dykman21 Sep
    • RE: incremental name search?Jerry Schwartz21 Sep
      • RE: incremental name search?Martin Gainty21 Sep
      • RE: incremental name search?Mike Spreitzer21 Sep
        • RE: incremental name search?Jerry Schwartz21 Sep
          • RE: incremental name search?Gavin Towey22 Sep
RE: incremental name search?Mike Spreitzer21 Sep
  • RE: incremental name search?Jerry Schwartz21 Sep