Forum: Ruby on Rails activerecord utf8 special characters odd behavior

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
E99bd8b18ab2130f1cd23eb0dd4b2d40?d=identicon&s=25 philip.mcallister@gmail.com (Guest)
on 2007-04-03 07:32
(Received via mailing list)
Since upgrading to Rails 1.2.* my ActiveRecord has not been acting
properly:

When I perform a .find and give a UTF8 string as a conditional, the
select statement gives me the following:

SELECT * FROM albums WHERE (name = 'MedĂșlla')

When I perform a .save on a model UTF8 and other characters ( . ! )
get stripped out of the query:

INSERT INTO albums (`name`) VALUES('Medlla')

The database encoding is set to utf8 in the database.yml file.
character_set_database and character_set_system are both set to utf8
in the mysql database.

Thoughts?
This topic is locked and can not be replied to.