Thread: Case Sensitive problem

"Erik Ferencz" <ErikFerencz@seznam.cz> writes:

> Hi,
> I have got problems with case sensitive sort.
> My Postgre DB is Case sensitive but I need case insensitive.
> Could anyone help me,please.
> I don't know where or how to set this option.

It's not an option you can set.  Just do "ORDER BY upper(mycolumn)".

-Doug

Erik Ferencz wrote:
> Hi,
> I have got problems with case sensitive sort.
> My Postgre DB is Case sensitive but I need case insensitive.
> Could anyone help me,please.
> I don't know where or how to set this option.

What output do you get and what do you expect to get?

It sounds like a locale issue, I'm not sure if you can change this on
the fly though.

--
Postgresql & php tutorials
http://www.designmagick.com/