Re: How to perform a simple search ignoring characters with accents (á, é, í, ó, ú)

On Jun 4, 4:20 pm, Peter of the Norse <RahmC...@Radio1190.org> wrote:
> One possibility is to use MySQL. By default it indexes things so that a, á, and À are the same thing. There are some gotchas though: you have to make sure that it's using an appropriate character set for the languages you're using. (UTF-8 is a good choice.) There's not a good similar solution for PostgreSQL. While it is possible to write a function, and create an index on that function, I haven't found a way of searching on that index in Django. If anyone knows of a way to do it, I'd love to here it.

.extra() will likely allow what you are looking for. But
using .extra() tends to get ugly fast.

- Anssi

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.