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: jschwa...@the-infoshop.com > To: mdyk...@gmail.com; mspre...@us.ibm.com > CC: mysql@lists.mysql.com > 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:mdyk...@gmail.com] > >Sent: Monday, September 21, 2009 12:21 PM > >To: Mike Spreitzer > >Cc: mysql@lists.mysql.com > >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 <mspre...@us.ibm.com> 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=mdyk...@gmail.com > >> > >> > > > > > > > >-- > > - michael dykman > > - mdyk...@gmail.com > > > >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=jschwa...@the- > >infoshop.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com > _________________________________________________________________ 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