I have a strange one here but there’s probably a very simple solution (though I’ve been unable to google it).
I have a varchar(100) column called name (t.string :name, :limit => 100, :null => false).
I have a …
:scope => :event_group_id,
:case_sensitve => false
which is producing the following SQL …
event_categories WHERE (
name = BINARY ‘road’ AND
event_categories.event_group_id = 790727023) LIMIT 1;
Note the BINARY in the query. How could this happen?
I have other requests to that table (JQuery autocomplete, for example) and it doesn’t introduce the BINARY.
I am running MySQL version 5.1.49-1ubuntu8.1
Any pointers would be great