Re: searching accents

[Frank Miedreich <miedreich@acm.org>]

>******    message to minivend-users from "Alessandro Scudieri"
><scudieri@balbi.unige.it>     ******
>
>Hi all,
>
>The search with my search form fail when the search string contains accented
>characters (accents are very frequent in italian).
>I.E. if I search "cecit&#224;" (with the &agrave;) the response is "no matches",
>even if there is a record with this word in it.
>Any suggestion ?
>
>TIA
>Alessandro Scudieri - Pangea.It
>scudi@pangea.it
>

There are two possible solutions:

1: do the character translation in mv_click on searchpage with package
HTML::Entities if your database source file contains the HTML Entities.

2: Use ISO-5589/1 character set in the database source file.

I always use solution 2 as it has the additional positive effect of making
the database source readable. I never understood the idea behind HTML
entities anyway: Use human readable escape sequences to transform human
readbale text into &gobbledigook;.

Frank

--
Frank Miedreich
Max-Planck-Institut fuer psychologische  Forschung
Leopoldstr. 24   80802 Muenchen   +49 89 38602-237