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

Hi, if you are using postgreSQL, I released a week ago a library to do
just what you need: see: https://github.com/djcoin/django-unaccent/

Once you got the `unaccent` function set up in your postgreSQL db, you
can make unaccented search from the Django ORM as usual.
Eg: Given a book title of "The book of Café",
`Book.objects.filter(title__icontains_unaccent='Cafe')` will match

Cheers,
Simon

On Jun 1, 7:03 pm, Joni Bekenstein <jonibekenst...@gmail.com> wrote:
> I need to do a simple search ignoring some characters with accents. The
> idea would be that "hola" matches the search term "holá".
>
> What I'm currently doing is adding a CharField to my model to store the
> searchable term. For example:
>
> class Book(models.Model):
>   title = models.CharField(max_length=100)
>   searchable_title = models.CharField(max_length=100)
>
> When I save a Book I'll replace the accented characters in title with their
> non-accented counterparts and store the result in searchable_title. The,
> I'll also do the same thing with the search term before actually doing the
> query.
>
> I don't like this approach because if I need to add more searchable fields
> things start getting noisy in my models.
>
> Any ideas?

--
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.