> Thanks for your replies. > > Probably I didn't explain my problem well. I am using > a third party tool which I'll be installing on > Solaris machine, and that tool is using Postgres as > the database. The queries are hardcoded in it and I > can not change them. So right now when I do 'initdb' > without specifying '-locale' or '-lc-collate', I see > that the 'order by' clause returns me 'case > sensitive' search. > > And therefore the third party tool also returns me > case sensitive results. > > I need postgres to be installed in a way so that > 'order by' clause itself returns me > 'case-insensitive' search and I don't have to use > upper() or lower() functions in the query. > > Thanks for all your help > Regards > Anubha
Don't know postgres from postnasal drip (ok, I know one is a database), but here's a simple example of the sort of collating behavior you're talking about: $ mkdir test $ cd test $ touch aa Ab bb Bc $ env LC_COLLATE=C ls -1 Ab Bc aa bb $ env LC_COLLATE=en_US.ISO8859-15 ls -1 aa Ab bb Bc (en_US.UTF-8 gave the same result as the second example above) -- This message posted from opensolaris.org _______________________________________________ opensolaris-discuss mailing list [email protected]
