Awesome guys. Thanks to everyone for all the help. I must have missed the Lighthouse case. I'll keep tabs on that to make it in to future releases of DM. We'll monkey-patch in the mean time.
Thanks, -J On Wed, Nov 11, 2009 at 1:47 PM, Roy Wright <r...@wright.org> wrote: > 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 -~----------~----~----~----~------~----~------~--~---