On Sun, 25 Jan 2009 19:06:12 +0000, Paul Makepeace wrote: > Does anyone know of a CPAN module that'll switch the various > apostrophes to ', dashes to -, etc.? `A la the demoroniser, > http://www.fourmilab.ch/webtools/demoroniser/ > > The issue I'm running into is our database has data like "L'Express" > but could be queried with L'Express or LŽExpress or who knows what. > So, what would be particularly sexy is if DBIx::Class could auto- > replace this junk before going anywhere near the DB, e.g. search() > and insert() would convert any dodgy high-bit characters to their > ASCII versions first. Text::Unidecode ought to do something like what you want for the 8+ bit characters, but you'll have to sort out the backquotes yourself (though you could hack its lookup tables) -- Peter Haworth pmh@edison.ioppublishing.com "I would therefore like to posit that computing's central challenge, viz 'How not to make a mess of it', has not been met." -- Edsger W Dijkstra