Re: Accent-insensitive queryset filter

[Jarek Zgoda]

Wiadomość napisana w dniu 2009-08-20, o godz. 09:04, przez A Melé:

>
> PostgreSQL. It seems that it is accent-sensitive by default.
>
> On 20 ago, 03:57, Karen Tracey  wrote:
>> On Wed, Aug 19, 2009 at 6:47 PM, A Melé   
>> wrote:
>>
>>> Is there any way to perform an accent insensitive match when you are
>>> filtering a queryset? I'm looking for something like iexact (http://
>>> docs.djangoproject.com/en/dev/ref/models/querysets/#iexact) but  
>>> accent-
>>> insensitive. Is there any simple way to do it?
>>
>> What database? MySQL's default collation does this, offhand I don't  
>> know how
>> others behave.

PostgreSQL uses POSIX LC_COLLATE setting for collation specified in  
template used to create the database, so currently this is not  
possible. There was some project during GSOC 2008 to allow database- 
level collation definitions for PostgreSQL (CREATE COLLATION etc.),  
but I don't know the result.

-- 
Artificial intelligence stands no chance against natural stupidity

Jarek Zgoda, R, Redefine
jarek.zg...@redefine.pl


--~--~-~--~~~---~--~~
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+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Re: Accent-insensitive queryset filter

[A Melé]

PostgreSQL. It seems that it is accent-sensitive by default.

On 20 ago, 03:57, Karen Tracey  wrote:
> On Wed, Aug 19, 2009 at 6:47 PM, A Melé  wrote:
>
> > Is there any way to perform an accent insensitive match when you are
> > filtering a queryset? I'm looking for something like iexact (http://
> > docs.djangoproject.com/en/dev/ref/models/querysets/#iexact) but accent-
> > insensitive. Is there any simple way to do it?
>
> What database? MySQL's default collation does this, offhand I don't know how
> others behave.
>
> Karen
--~--~-~--~~~---~--~~
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+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Re: Accent-insensitive queryset filter

[Karen Tracey]

On Wed, Aug 19, 2009 at 6:47 PM, A Melé  wrote:

>
> Is there any way to perform an accent insensitive match when you are
> filtering a queryset? I'm looking for something like iexact (http://
> docs.djangoproject.com/en/dev/ref/models/querysets/#iexact) but accent-
> insensitive. Is there any simple way to do it?
>

What database? MySQL's default collation does this, offhand I don't know how
others behave.

Karen

--~--~-~--~~~---~--~~
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+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---

Accent-insensitive queryset filter

[A Melé]

Is there any way to perform an accent insensitive match when you are
filtering a queryset? I'm looking for something like iexact (http://
docs.djangoproject.com/en/dev/ref/models/querysets/#iexact) but accent-
insensitive. Is there any simple way to do it?

Thank you!
--~--~-~--~~~---~--~~
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+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---