Hello....
Does anyone understand what is meant by a case-insensitive database.
Are there some collations that can be changed or is there just no way to
have a true case-insensitive Postgresql database?
Thanks
"Dennis Gearon" <gearond@fireserve.net> wrote in message
news:3F64CA36.5010202@fireserve.net...
> Relaxin wrote:
>
> >No, I mean the data.
> >
> >select * from stocks where symbol = 'AADBX'
> >and
> >select * from stocks where symbol = 'aadbx'
> >
> >would bring up the same result set.
> >
> >
> >
> Look in the manuals, there are SQL functions like:
>
> STRTOLOWER( ); STRTOUPPER() like those in 'C'
>
> Usage:
> -------
> SELECT *
> FROM stocks
> WHERE
> STRTOLOWER( symbol ) = STRTOLOWER( 'AADBX' );
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>