search for: collation_database

...| | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | 0 | | concurrent_insert | 1 | | connect_timeout...

...666'' and metrocode = ''0'' and areacode = ''0'' > and isp = ''UPC Magyarorszag Kft.'' and organization = ''UPC > Magyarorszag Kft.'' limit 1 mysql collation variables are set to. collation_connection latin1_swedish_ci collation_database utf8_general_ci collation_server utf8_general_ci mysql character set are set to. character_set_client latin1 character_set_connection latin1 character_set_database utf8 character_set_filesystem binary character_set_results latin1 character_set_server utf8 character_s...

...Parameters: {"score"=>{"score"=>"79.60", "player_name"=>"一", "iphone_identifier"=>"6b194f783d645ba1a7c30c0e31b1b67300eb0a25"}, "product_id"=>"7"} ^[[4;35;1mSQL (0.1ms)^[[0m ^[[0mSET collation_database = ''utf8_general_ci'' ^[[0m ^[[4;36;1mSQL (0.1ms)^[[0m ^[[0;1mSET collation_connection = ''utf8_general_ci'' ^[[0m 7--- !map:HashWithIndifferentAccess score: "79.60" player_name: !binary | 5LiA iphone_identifier: 6b194f783d645ba1a7c30c0e31b1b67...

Hi! I have ran on problem with collations. In database.yml I have set: encoding: utf8, but when in console run: >> ActiveRecord::Base.connection.collation => "latin1_swedish_ci" It is Rails 2.1, mysql gem 2.7, mysql 5.1.22. This leads to errors like: Mysql::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation

Any thoughts on how to avoid this problem? Already tried: 1. Setting the charset and collation in migration 001 - no effect: def self.up db_name = ActiveRecord::Base::connection.current_database() execute "ALTER DATABASE #{db_name} CHARACTER SET utf8 COLLATE utf8_bin" end 2. Setting the charset and collation on each table individually - no effect:

Hi, I have some seed data in MySql which contains non-ASCII characters (as you''d imagine as these are worldwide placenames that I''m storing). In MySql on the command line they look great, they''re all formatted perfectly, including Arabic and Chinese characters and they look great. However, when I ask my Rails model for one of these fields, and render that in the