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

-- 
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.

Reply via email to