On Mar 31, 2007, at 11:56 PM, Rainer Kern wrote: > I just installed and set up ferret and act_as_ferret for rails. All of > them at the most recent version. The development environment is > running > fine with Mac OS X. But I got problems with the productive environment > (debian). > > In the (mysql-)database are few records stored, containig german > umlauts > (ü for example). Running a query for "köln" returns the correct record > in dev-environment but NOTHING at the debian system. But the logs are > looking good. It seems the word was correctly submited:
Your system locale should be set to UTF-8. Use the 'locale' command to view the current settings and change the LANG and LC_ALL environment variables if necessary. (In your case they should probably be set to "de_DE.UTF-8") MySQL should be configured to use UTF-8 as well. You can either specify the character set for each individual table (via the CREATE TABLE command) or globally in my.cnf: character-set-server = utf8 default-character-set = utf8 Finally, for Rails, add the following lines to environment.rb: $KCODE = 'u' require 'jcode' I recommend to use UTF-8 throughout the whole stack (OS, MySQL, Rails). That way you'll get rid of your encoding problems once and for all. Cheers, Andy _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
