In master branch I have removed LOWER functions, and now it should use ILIKE
in postgres. Other databases will use LIKE, but LIKE is case insensitive in
mysql and others.
On Martes, 14 de Septiembre de 2010 17:31:16 coalex escribió:
> Thanks for the suggestion Sergio. My encoding appears to be set
> correctly.
>
> To get the explicit type casting to work with psql (PostgreSQL) 8.4.2:
> I just added '::TEXT' for the finder.rb helper. of ActiveScaffold
>
> In,
> vendor/plugins/active_scaffold/lib/finder.rb
>
> line 14:
> where_clauses << "LOWER(#{column.search_sql}::TEXT) LIKE ?"
>
> and ..
>
> line37:
> ["LOWER(#{column.search_sql}::TEXT) LIKE ?", like_pattern.sub('?',
> value.downcase)]
>
>
> cheers,
> a
--
Sergio Cambra .:: entreCables S.L. ::.
Mariana Pineda 23, 50.018 Zaragoza
T) 902 021 404 F) 976 52 98 07 E) [email protected]
--
You received this message because you are subscribed to the Google Groups
"ActiveScaffold : Ruby on Rails plugin" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/activescaffold?hl=en.
