Skip site navigation (1) Skip section navigation (2)

case-(in)sensitive Server

From: Daniel Grob <dgrob(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: case-(in)sensitive Server
Date: 2002-06-13 14:52:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Hi all,

we are here using PostgreSQl 7.1.3 on SUSe 6.4 with Windows 2000 Clients via
ODBC. When I now try to search with OpenOffice 1.0 (from the Client) for
"Test" and its written "test" I cant't found it. 
I know that I can search case insensitive in the SQL-Prompt (found serveral

But my Problem is: The people from the sales dept. use OpenOffice and they
use the integrated Search.

My Question is: Can I make the Postgres Server case-insensitive? - And if
yes, how?

Thanks for help 


GMX - Die Kommunikationsplattform im Internet.


pgsql-novice by date

Next:From: Josh BerkusDate: 2002-06-13 16:25:16
Subject: Re: case-(in)sensitive Server
Previous:From: Dave CramerDate: 2002-06-13 14:44:46
Subject: Re: Shouldn't "aborted transaction" be an ERROR? (was Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group