On Dec 21, 8:48 pm, Marnen Laibow-Koser <li...@ruby-forum.com> wrote: > > Victor Cisneiros wrote in post #969879: > > > I tried running on my linux VPS with Ruby 1.9.2 and the mysql2 gem and > > the problem still persists > > > The funny thing is that I have a view where you can filter all the > > clients and if I make it filter this particular client by running this > > query > > > SELECT `clients`.* FROM `clients` WHERE (nome LIKE '%João Victor > > Santos%') ORDER BY nome ASC LIMIT 30 OFFSET 0 > > > It correctly returns 1 row > > > I'm starting to think the problem is with the BINARY in the validates > > uniqueness query, anyone knows a way to monkey-patch it to remove the > > BINARY keyword? > > That's probably not the issue. Did you investigate the encodings as I > suggested in my earlier post?
It could be/ BINARY forces the comparison to be done byte by byte, but (assuming the column is a utf8 one) the character ã can be represented with more than one sequence of bytes. Fred -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.