Re: [GENERAL] Case Sensitive problem

2006-03-15 Thread Chris
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

Re: [GENERAL] Case Sensitive problem

2006-03-15 Thread Douglas McNaught
"Erik Ferencz" <[EMAIL PROTECTED]> 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(m