Index: user_patch.rb
===================================================================
--- user_patch.rb	(revision 9)
+++ user_patch.rb	(working copy)
@@ -6,7 +6,7 @@
       base.class_eval do
         unloadable
 
-        scope :with_name,->(name) { where('LCASE(CONCAT(firstname," ",lastname)) like ?', "#{name.downcase}%")}
+        scope :with_name,->(name) { where('LOWER(CONCAT(firstname,N\' \',lastname)) like ?', "#{name.downcase}%")}
       end
     end
   end