just execute ALTER TABLE table_name MODIFY column text CHARACTER SET utf8
this will do the trick Witold Rugowski wrote: > MaurĂcio Linhares wrote: >> Have you looked at this specific table to see it's collation and >> encoding? > Yes, of course: > mysqldump -d --create-options -u root -p DATABASE tags > > DROP TABLE IF EXISTS `tags`; > SET @saved_cs_client = @@character_set_client; > SET character_set_client = utf8; > CREATE TABLE `tags` ( > `id` int(11) NOT NULL AUTO_INCREMENT, > `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL, > PRIMARY KEY (`id`), > KEY `index_tags_on_name` (`name`) > ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8; > SET character_set_client = @saved_cs_client; > > > Problem is that connection collation is set wrong. I did ugly hack and > at end of environment.rb I have added: > > ActiveRecord::Base.connection.execute "SET collation_database = > 'utf8_general_ci' " > ActiveRecord::Base.connection.execute "SET collation_connection = > 'utf8_general_ci' " > > > And it works: >>> ActiveRecord::Base.connection.collation > => "utf8_general_ci" > > > -- > Witold Rugowski > Ruby on Rails freelancer > http://nhw.pl/wp/ (EN blog) http://nhw.pl/pl (PL blog) -- Posted via http://www.ruby-forum.com/. -- 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.