2

I am using Sqlite3 which comes default with rails 3. How to change a particular column to collate NOCASE with a rails migration?

I tried out t.change :name, :string, :collate => "NOCASE", but the case insensitive search for find_by_name("test", :order => "name collate NOCASE") gives no result as expected?

Karthick
  • 41
  • 4

1 Answers1

0

I guess the format might be the issue. Try:

:COLLATE => :NOCASE
AshwinKumarS
  • 1,303
  • 10
  • 13