Re: Disabling case sensitivity

On 15 Jul 2002, igor wrote:

> > Being able to ignore the difference strictly in terms of case
> > (appropriately defined by locale) is what things like ILIKE are for.
> > But "=" means "the same", not "sort of the same".
> >
> In case-insensitive world yes.
>
>
> > If your application can't be fixed, and relies entirely on some
> > (non-)feature of some other system, well, then, you have to use that
> > other system. Them's the breaks.
> >
>
> Or wait until (if so) there will be possibility in POstgreSQL server
> to make smething like case-insensitive searches.

If you have a locale where those characters are considered the same,
presumably you'd get case-insensitive searches if the database was made in
that locale. Barring that, you have source, you could go in and muck with
the appropriate functions.