Thread: Full Case INSENSITIVE ...

Full Case INSENSITIVE ...

From
"Nicola Cisternino"
Date:
Hi,
 
... We are a Microsoft SQL Server users by many years .... and now we would like migrate our applications on PostgreSQL ... .but for us is very important the case function in query operations ....
SQL Server databases can be case-sensitive or case-insensitive depending on installation options.
If a database is case-sensitive, when you search for text data, you can use any combination of uppercase and lowercase letters. For example, if you are looking for a name such as "Smith," you can use the search conditions "=smith" or "=SMITH." ... so as you can search any data with all standard operators ( ">" "<" ... etc...) without lost any record ! ....
 
It's possible with PostgreSQL ???  ( .... i already know the ILIKE clause .... but it's insufficient !! ...)
 
It will be a future implementation  ???
 
Very thanks !!

Re: Full Case INSENSITIVE ...

From
Karel Zak
Date:
On Fri, Jul 27, 2001 at 01:31:56PM +0200, Nicola Cisternino wrote:
> Hi,
>
> ... We are a Microsoft SQL Server users by many years .... and now we
> would like migrate our applications on PostgreSQL ... .but for us is
> very important the case function in query operations ....
> SQL Server databases can be case-sensitive or case-insensitive depending
> on installation options.
> If a database is case-sensitive, when you search for text data, you can
> use any combination of uppercase and lowercase letters. For example, if
> you are looking for a name such as "Smith," you can use the search
> conditions "=smith" or "=SMITH." ... so as you can search any data with
>  all standard operators ( ">" "<" ... etc...) without lost any record ! ....
>
> It's possible with PostgreSQL ???  ( .... i already know the ILIKE clause .... but it's
> insufficient !! ...)

 What is insufficient? You can use a lot of solutions for case insensitive
oprations, like LIKE/ILIKE, upper(foo)=upper(bar), etc.

 See mailing list arhives, it's already discussed theme.

> It will be a future implementation  ???

 very unsure...

                Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Re: Full Case INSENSITIVE ...

From
Stephan Szabo
Date:
On Fri, 27 Jul 2001, Nicola Cisternino wrote:

> Hi,
>
> ... We are a Microsoft SQL Server users by many years .... and now we
> would like migrate our applications on PostgreSQL ... .but for us is
> very important the case function in query operations .... SQL Server
> databases can be case-sensitive or case-insensitive depending on
> installation options. If a database is case-sensitive, when you search
> for text data, you can use any combination of uppercase and lowercase
> letters. For example, if you are looking for a name such as "Smith,"
> you can use the search conditions "=smith" or "=SMITH." ... so as you
> can search any data with all standard operators ( ">" "<" ... etc...)
> without lost any record ! ....
>
> It's possible with PostgreSQL ???  ( .... i already know the ILIKE
> clause .... but it's insufficient !! ...)
>
> It will be a future implementation  ???

Probably not directly that way.  Probably you'd be able to do it through
all the mutant SQL character classing stuff when that's implemented.

I don't know much about the locale stuff, but I'd guess that right now
if you could find a locale which treated those characters as equivalent,
you'd probably be able to get truly insensitive searches.  (I don't know
if that's even possible to specify in locales, but I'm sure someone who
knows will pipe up with an answer now :) )