Re: icontains case-sensitive on MySQL

2015-05-31 Thread Mike Dewhirst
On 1/06/2015 5:57 AM, Jake Gordon wrote: There needs to at least be a warning in the documentation. https://docs.djangoproject.com/en/1.8/ref/databases/#collation-settings I spent a lot of time debugging only to find this was a problem with Django. On Thursday, October 16, 2008 at 6:56:07 P

Re: icontains case-sensitive on MySQL

2015-05-31 Thread Jake Gordon
There needs to at least be a warning in the documentation. I spent a lot of time debugging only to find this was a problem with Django. On Thursday, October 16, 2008 at 6:56:07 PM UTC-4, Malcolm Tredinnick wrote: > > > On Thu, 2008-10-16 at 11:15 -0700, AndyB wrote: > > Well - someone on #Djang

Re: icontains case-sensitive on MySQL

2008-10-16 Thread Malcolm Tredinnick
On Thu, 2008-10-16 at 11:15 -0700, AndyB wrote: > Well - someone on #Django told me to check encoding settings and I did > but I failed to read the following: > http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html > > Using binary collation changes the default sensitivity of string > com

Re: icontains case-sensitive on MySQL

2008-10-16 Thread AndyB
Well - someone on #Django told me to check encoding settings and I did but I failed to read the following: http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html Using binary collation changes the default sensitivity of string comparisons. Is this not something that Django should be abstra

Re: icontains case-sensitive on MySQL

2008-10-16 Thread Ronny Haryanto
On Fri, Oct 17, 2008 at 12:55 AM, AndyB <[EMAIL PROTECTED]> wrote: > I've googled and the only problems seem to be with people trying to do > case-sensite lookups. > > What could be going wrong here?: > b.filter(name__icontains='Saff') > [] b.filter(name__icontains='saff') > [] Could yo

icontains case-sensitive on MySQL

2008-10-16 Thread AndyB
I've googled and the only problems seem to be with people trying to do case-sensite lookups. What could be going wrong here?: >>> b.filter(name__icontains='Saff') [] >>> b.filter(name__icontains='saff') [] MySql 5.0.51 Django 1.0 Tables are InnoDB UTF8 collation UTF8 bin Tried it on a my dev ma