X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 9AB3E30F503; Mon, 23 Jun 2003 09:27:11 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024)
	with ESMTP id 19348-05; Mon, 23 Jun 2003 06:27:00 -0300 (ADT)
Received: from mailhost3.tudelft.nl (mailhost3.tudelft.nl [130.161.180.83])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 3DA7A30F233; Mon, 23 Jun 2003 06:27:00 -0300 (ADT)
Received: from 127.0.0.1 (localhost [127.0.0.1])
	by rav.antivirus (Postfix) with SMTP
	id 56DE6424; Mon, 23 Jun 2003 11:27:00 +0200 (MEST)
Received: from listserv.tudelft.nl (listserv.tudelft.nl [130.161.180.33])
	by mailhost3.tudelft.nl (Postfix) with ESMTP
	id 42991421; Mon, 23 Jun 2003 11:27:00 +0200 (MEST)
Received: from acm (x193056-2.shuis-s.tudelft.nl [145.94.193.58])
	by listserv.tudelft.nl (8.12.8p1/8.12.8) with ESMTP id h5N9PkDb021836;
	Mon, 23 Jun 2003 11:26:59 +0200 (MEST)
From: "Arjen van der Meijden" <acm@tweakers.net>
To: <nolan@celery.tssi.com>
Cc: "'\"Advocacy PostgreSQL\"'" <pgsql-advocacy@postgresql.org>,
	"'PostgreSQL-general'" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: Mon, 23 Jun 2003 11:25:47 +0200
Message-ID: <000b01c33969$982ed060$3ac15e91@acm>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2627
In-Reply-To: <20030623025439.28324.qmail@celery.tssi.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Importance: Normal
X-Archive-Number: 200306/183
X-Sequence-Number: 1395

> nolan@celery.tssi.com wrote:

> MySQL also does case independent text comparisions, and 
> apparently ONLY case-insensitive comparisons.  

It's not very clearly described in the manual. But if you either specify
your textual fields 'binary' or use some form of 'like ... binary' query
it'll compare them case-sensitive, (apart from the strcmp-functions).

And in the case of a binary textual field the indices are also
case-sensitive :)

Regards,

Arjen