Here's a ticket on the issue: http://datamapper.lighthouseapp.com/projects/20609/tickets/1105-add-support-for-definingchanging-default-collation
Sounds like you might be able to monkey patch as a work around. And here's the documentation on the mysql collation: http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html HTH, Roy On Nov 11, 2009, at 11:34 AM, Jeff Pollard wrote: > Roy, > > Thanks for the reply. That does help us replicate the :unique => > true bit of what we want, but our bigger problem is calling like > Keyword.first(:text => "Polish"), and getting the row for "polish" > instead since it appears first in the data store. We had talked > about extending methods like .first for the Keyword class to account > for this, but that seemed less elegant than declaring the correct > property data type. > > Thanks, > > -J > > On Wed, Nov 11, 2009 at 12:35 AM, Roy Wright <r...@wright.org> wrote: > > > On Nov 11, 2009, at 12:44 AM, Fluxx wrote: > > > > > We're currently building an application that has a Keyword model, > with > > a :text property that stores the text of the keyword (class > > declaration below). The :text property needs to be case > sensitive, so > > a :text of "Polish" and "polish" would be considered two different > > records. > > > > > Not the prettiest, but this might get you heading the in a workable > direction: > > http://gist.github.com/231789 > > BTW, I first confirmed the difference between sqlite and mysql on case > sensitive uniqueness. > > HTH, > Roy > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to datamapper@googlegroups.com To unsubscribe from this group, send email to datamapper+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---