From: Martin B. Jespersen
Date: March 16 1999 12:33pm
Subject: Re: DISTINCT weirdness..
List-Archive: http://lists.mysql.com/mysql/320
Message-Id: <36EE4F8A.E5227C8B@IconMedialab.dk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> I appreciate any ideas how to do it better.  The problem is to make
> everything 'hold' together.  I think that the DISTINCT should compare
> the strings the same way as the normal compare operations, and this
> put some restrictions how things can be solved.
> 
> Regards,
> Monty

I must agree that DISTINCT should behave like normal comparison, which is
dependant on the binary attribute. It would though be nice if you could compile
MySQL with binary as default, and then you would have to set ascii (or whatever)
explicit if you want to have non-binary strings. If this is already possible
then RTFM to me :)

-- 
Martin B. Jespersen
Technical Project Leader
Icon Medialab A/S (http://www.IconMedialab.dk)

E-Mail: Martin@stripped
Mail:   Havnegade 39, DK-1058 Copenhagen K
Voice:  (+45) 7023-1001
Fax:    (+45) 33320209