Hello,
I am using rails 2.1 and mysql with utf8
>> Character.all(:conditions => { :name => ''à'' })
=> [#<Character id: 2, name: "a">, #<Character id: 56,
name: "à">]>> Character.all(:conditions => { :name => ''à''
}).last.name
=> "à">> Character.all(:conditions => { :name => ''à''
}).last.name == ''a''
=> false>> Character.all(:conditions => { :name => ''à''
}).last.name == ''à''
=> true
I use uniqueness validation on the name column and it correctly does not
complain that a is the same as à. Also ruby-internally the two strings/chars
are different.
but when I do retrieval they are conflated and considered identical? see
above and also:
Character.find_all_by_name(''a'')
=> [#<Character id: 2, name: "a">, #<Character id: 56,
name: "à">]>> Character.find_all_by_name(''à'')
=> [#<Character id: 2, name: "a">, #<Character id: 56,
name: "à">]
Also, using find_or_create_by_name works incorrectly.
What am i doing wrong? Is this a bug somewhere?
Thanks for help
Vik
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---