Friday, June 5, 2009

[jQuery] Re: [autocomplete] hard time with accent

On 6/4/09 2:17 PM, "James" <james.gp.lee@gmail.com> wrote:

> What are you using to do the string matching?

depends on the kind of search i need.

> For me, I was using autocomplete to search for something stored in a
> MySQL database,

i think that's a very common scenario.

> and MySQL by default automatically matches even those
> strings with accents from non-accented characters.

according to collation.

> It should either be
> the script or the database that handles this conversion/matching.

if by "script" you mean client script then i can't agree. say i wanted more
than a simple search, i want exact matches frist, then prefix matches in
lexical order, and finally fuzzy matches in Damerau-Levenshtein order with
lexical suborder. the right place for much of that work is in the backend
script.

btw: if you use a php backend then converting character encodings is very
easy.

No comments: