not sure if this is what you are asking, but... I usually do something like this for queries that I want to be case insensitive
# force both to upper :conditions => ['UPPER(email) = ?', params[:search][:email].upcase] # use postgres ILIKE which is case insensitive :conditions => ['email ILIKE ?', "%#{params[:search][:email]}%"] that way I can leave the data alone however this is not portable across all databases, there might be a better way - Jesse On Feb 18, 11:32 am, Lille <lille.pengu...@gmail.com> wrote: > Hi, > > I'm new to PostgreSQL and I've read in a few places that it may treat > string case sensitivity particularly when searching. Thus, I'm > wondering if I should consider scrubbing my string data any particular > way in advance of deployment on Heroku? > > Lille -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.