Re: Filtering and the letter å

On Aug 8, 1:45 pm, finn <finngruwierlar...@gmail.com> wrote:
> I am developing a web application for maintaining spellcheck
> dictionaries. I have noticed that when I filter database records like
> this:
>
>     words = Word.objects.filter(lemma='male')
>
> I'll also get 'måle' among the hits. This is also the case for its
> uppercase counterpart, Å. However, I don't get the same behaviour for
> other Scandinavian letters like ø/Ø.
>
> Could this be a bug?

Functions like filtering and sorting are performed by your database.
And databases use something called 'collation' to determine which
letters are considered equal in queries. In your case I would check
the collation of your tables, and look in the documentation for your
database to work out which collation to use if you want to change the
current behaviour.
--
DR.

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