On Oct 1, 2008, at 8:48 PM, Morgan Kay wrote:
> I have been reading up on collation settings, and I'm not sure it will > do what I want. I don't want to get rid of accented characters (which > is what would happen if I changed character sets), I just don't want > searches to get thrown off by them. In other words, a search for > "Chrétien" or "Chretien" should still find "Chrétien", and he should > still have the accent in his name. Can collation settings do this for > me, or is there some other solution? One approach is to transliterate your input, e.g.: http://interglacial.com/~sburke/tpj/as_html/tpj22.html -- Sean M. Burke, Unidecode!, 2001 That way, "Chrétien" becomes "chretien" or some such for the purpose of your search, but remains "Chrétien" in the text. For example, both El-Aaiún and El-Aaiun could reference the same underlying text: http://svr225.stepx.com:3388/El-Aaiún http://svr225.stepx.com:3388/El-Aaiun Cheers, -- PA. http://alt.textdrive.com/nanoki/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
