Re: Why Not MySQL?

The Hermit Hacker wrote:
>
> On Wed, 3 May 2000, Hannu Krosing wrote:
>
> > Malcontent null wrote:
> > >
> > > >Anyway, so the larger class of problem is for the Sybase/M$ user who
> > > >relies on case insensitive queries (which *are* available in Postgres)
> >
> > Maybe the right place to introduce case-insensitiveness would be in ODBC
> > driver then ?
> >

...

> > > 2) Case insensitive queries.
> >
> > Probably only the Access subset ("like", "order by", maybe even "=" ?)
>
> don't we have a 'lower()' function?
>
> SELECT * FROM <table> WHERE field ~* 'this string' ORDER BY lower(field);?
>
> or
>
> SELECT * FROM <table> WHERE lower(field) = lower('StriNg');

That's what I meant by introducing pushing the case-insensitiveness into ODBC,
so that the MS Access program can be made case-insensitive automatically by

A) rewriting the queries to use lower()

or

B) by using case-insensitive operators where possible.

----------------
Hannu