This approach seems reasonably portable to me. It's worth mentioning that if
you're at the point where you're wondering whether there are subtle
differences between PostgreSQL, MySQL and sqlite, you're at the point where
you should just install PostgreSQL on your dev machine. It's really not hard
at all.
As always, heroku apps are free and easy to make. I usually have a couple
apps that I just use to push speculative code to for testing at any given
point when I suffer from these kinds of questions myself. Works great!
Best,
Peter
Dep't of Data
On Sat, Feb 19, 2011 at 9:02 AM, Jesse House <jesse.ho...@gmail.com> wrote:
> 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.
>
>
--
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.
