"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > If upper() and lower() operate on characters in 8859-1 and other character > sets when the appropriate locale is set, then a difference in the behavior > of upper() and lower() would seem like a bug. Au contraire ... upper() and lower() are not symmetric operations in quite a few non-English locales. I'll let those who regularly work with them give specific details, but handling of accents, German esstet (sp?), etc are the gotchas that I recall. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
- [SQL] Case Insensitive Queries Mark
- [SQL] Case Insensitive Queries Dan Lyke
- Re: [SQL] Case Insensitive Queries [EMAIL PROTECTED]
- Re: [SQL] Case Insensitive Queries Jim Ballard
- Re: [SQL] Case Insensitive Queries [EMAIL PROTECTED]
- Re: [SQL] Case Insensitive Queries Tom Lane
- Re: [SQL] Case Insensitive Queries [EMAIL PROTECTED]
- Re: [SQL] Case Insensitive Queries Mark
- Re: [SQL] Case Insensitive Queries Mark
- Re: [SQL] Case Insensitive Queries Tom Lane
- Re: [SQL] Case Insensitive Queries Stephan Szabo
- Re: [SQL] Case Insensitive Queries Mark
- Re: [SQL] Case Insensitive Queries Stephan Szabo
- Re: [SQL] Case Insensitive Queries Mark
- Re: [SQL] Case Insensitive Queries Tom Lane
- Re: [SQL] Case Insensitive Queries ANDREW PERRIN