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.
--
Sean Legassick
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
