> The ENV['LANG'] value has to correspond to the encoding of the data you > want to index, so if your data is latin1, Ferret needs to run with such > a locale, i.e. ISO-8859-1. > > In such cases I dump the data as text, convert to utf8 (usually > with vim :set fileencoding=utf8), re-create the table with DEFAULT > CHARSET UTF-8 and re-import the data.
So I tried to get this to work in MANY different ways. I converted the encoding with vim, iconv, and mysqldump/import. I changed the table types. I tried this: http://textsnippets.com/posts/show/84 , I tried this: http://climbtothestars.org/archives/2004/07/18/converting-mysql-database-contents-to-utf-8/ No matter what I try, I get the same error when I change my environment.rb to en_US.utf8. If I set it to en_US.iso88591, everything works fine. If I could successfully convert my database to utf8 AND get it to work with ferret, I would love to. But I just can't get it. So.... I think I'm going to stick with latin1 for now. :( Thanks for your help, guys! Ian. -- Posted via http://www.ruby-forum.com/. _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
