> -----Original Message----- > From: Michel Deloux [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 20, 2005 3:06 PM > To: CF-Talk > Subject: Replace accented chars with unaccented ones > > Hi all. Our client is a canadian airplanes supplier with a > multilanguage web site(french-Canada, english-USA, spanish-Mexico). > For french and spanish site visitors users can provide info with > accented chars. For USA clients users enter all char with unaccented > chars because english language(keyboard) don't have any one accented > char. > > I would like to replace accented chars (like "é", "è" or "à") with non > accented ones ("é" -> "e", "è" -> "e", "à" -> "a") in our search script. > > When user enters "Montréal" I would like to find Montreal and Montréal > in our DB.
Does the DB have any Regular Expression or other complex search capability? The ability to search for something like "Montr(é|e)al" is what you're looking for, right? You can also do this easily in Verity (and Verity can easily index your database information regardless of the native capabilities of the DB). Using the language filters you may not actually have to ANYTHING - Verity's generally pretty smart about this stuff. But to make it explicit you'd do something like: <WILDCARD>'Montr[ée]al' Verity is deeper than a lot of people realize -- Oops, sorry, "realise" ;^) Check out the livedocs: http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentation&file=part_dev.htm Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215866 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
