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.
signature.asc
Description: This is a digitally signed message part
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
