----- Original Message -----
From: Sean Legassick <[EMAIL PROTECTED]>
To: Turbine <[EMAIL PROTECTED]>
Sent: Thursday, June 08, 2000 7:46 PM
Subject: Re: BasePeer Problem
> On Tue, Jun 06, 2000 at 10:01:47PM +0200, Leon Messerschmidt wrote:
> > > So DB should have:
> > >
> > > ignoreCase()
> > > respectCase() (which for MySQL adds a 'BINARY' prefix to an
expression)
> > > ignoreCaseInOrderBy()
> > > respectCaseInOrderBy()
>
> I've looked into the MySQL case sensitivity issue some more and
> discovered two things that break what I suggested:
>
> - The BINARY prefix is a prefix to the expression not a function wrapper
> around a column/value (e.g. BINARY TABLE.COLUMN = 'cAsEdTeXt' not
> BINARY(TABLE.COLUMN) = BINARY('cAsEdTeXt') ).
>
> - The BINARY prefix only works on MySQL 3.23, which is not yet a stable
> release.
>
> As case-sensitive matching is a bit of a minority sport anyway, I
> suggest we remove the two respectCase methods and worry about the MySQL
> issue if anyone ever actually cares.
>
> Leon - sorry to lead you on a wild goose chase, hope you don't mind
> making these further changes.
>
No problem - easier to take stuff out than to put them in :-). I'm writing
an exam tonight :-( so I'll probably won't have time to do it till tomorrow
morning, though.
~ Leon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
