And the winner is.... James Gregory. I owe you a beer. Next slug meeting. I'm the one with the 'I Love Mandrake' badge at the back of the room..
< lc_collate | C < lc_ctype | C < lc_messages | unset < lc_monetary | C < lc_numeric | C < lc_time | C < log_connections | on --- > krb_server_keyfile | unset > lc_collate | en_US > lc_ctype | en_US > lc_messages | en_US > lc_monetary | en_AU So Debian seems to be initialising postgres dbs with the first of these collate sequences meaning that whatever 'C' is seems to return case-sensitive search results. Mandrake's standard RPM implements postgres with en_US collation sequences which means it sorts AaBbCcDd which is what I'd be hoping for. There is an initdb option to change this standard behaviour. http://www.postgresql.org/docs/7.3/static/charset.html Was good for me. Other options to do with other 'where' parameters might have worked but would probably have lead to slower performance (lots of serial reads, no chance to use indexes) and icky workarounds. HTH Someone else someday. I did do a lot of googling for this subject but nothing jumped out at me. Thanks James and everyone else who helped.. Stuart > On Thu, 2005-01-06 at 13:08 +1100, [EMAIL PROTECTED] wrote: >> Nope but a nice try... Same SQL query both servers. Different result. >> >> Case insensitive searching is what I'm after as a default. > > I'm sorry, that query is far too white-space challenged for me to be > able to parse it, so I can't be much help in correcting your query. I > will say that if you want to do a case insensitive string match, 'ilike' > is the operator you're looking for. > > If you're seeing different string comparison behaviour between machines, > I'd be checking the encoding type of the data. Unfortunately I can't > remember how to do that, so you'll need to look it up. It's done on a > database level, IIRC. > > HTH, > > James. > > -- > SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ > Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
