Thorsten Mauch wrote:
>
> Hi
> Is it possible to setup a database that is case insensitive ?
I don't think you can compile with an case-insensitive flag - AFAIK. But
the workaround is to user the upper() function: SELECT * FROM MyTable
where upper(MyField) = 'UpperCaseString';
In your application that you connect to Postgres, you convert your
string to an upper case string.
> is it also possible with a multbyte database ?
It shouldn't make any difference.
Poul L. Christiansen