Re: How to achieve "accent-insensitive" searching
Steve Hay <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Richard Davis wrote: >Steve Hay wrote: > > >>You'd heard of case-insensitive searching. What about >>"accent-insensitive" searching? >> >> > > >Hi Steve > >No answers from here, I'm afraid, but it's an area that interests me, so >I'd love to hear how you do sort this out. Others must have solved this: >Google, for example, gives me similar (but not the same!?) results if I >search for "città" or "citta". > >Since you're working with a web front end, I wonder if there's any >mileage in adapting the PHP approach below, that manipulates HTML >entities to zap accents. I know it doesn't get to the heart of your >problem on the database/SQL side, but it's intriguing nonetheless. > > This is only useful if the characters are written as HTML character entities to start with. I'm working with characters encoded in UTF-8, so it's not really any use. >[snip] >P.S. I was also fascinated by this interesting article on related >problems of alphabetization: http://www.rostra.dk/alphabet/alpha_en.htm > That's all about sorting, which I haven't got to yet. First, I want the means to find the appropriate results to start with; sorting the results comes later. I was hoping that MySQL's various collations would suffice, but that article raises whole cans of worms that presumably won't be (can't be) covered by them. - Steve ------------------------------------------------ Radan Computational Ltd. The information contained in this message and any files transmitted with it are confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the sender immediately. The unauthorized use, disclosure, copying or alteration of this message is strictly forbidden. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Radan Computational Ltd. The recipient(s) of this message should check it and any attached files for viruses: Radan Computational will accept no liability for any damage caused by any virus transmitted by this email.