Rails - Sep 2006 - inserting utf8 value in unique column generates unexpected duplicate key error

I''m inserting the french word for "Hotel" (with a circumflex
over the
''o'') into a column that is a unique key on a table. 
Apparently the
insert statement is truncating the string to "H".

Additionally, when rails tries to select the french word for "Hotel",
the string is not truncated and the inserted record is not returned.

Presumably, I have my utf8 settings with rails and my mysql innodb
database screwed up. I did set uf8 on the table definition and in
database.yml, so I''m stumped.  Anyone else ever have this problem?


--~--~---------~--~----~------------~-------~--~----~
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-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---