search for: collation_connection

Hi all, I am trying to configure utf8 in mysql under centos6 to display special characters, like accents. I use this mysql instance to store plain syslog logs. I have configured this under my.cnf: [mysqld] init_connect = 'SET collation_connection = utf8_general_ci' init_connect = 'SET NAMES utf8' character-set-server = utf8 collation-server = utf8_general_ci [client] default-character-set = utf8 but it doesn't seems to work ... Any idea?? Thanks.

...character_set_results | latin1 | | 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...

...47.283'' and lng = ''18.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...

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

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

...;"一", "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: 6b194f783d645ba1a7c30c0e31b1b67300eb0a25 ^[[4;35;1mSQL (0.2ms)^[[0m ^[[0mSHOW VARIABLES LIKE ''collation_database''^[[...

Currently I'm using user_query = SELECT 1000 AS uid, 1000 AS gid, '/srv/vmail/%2.256Hu/%Lu' AS home, ... so I'm hashing based on %u (basically). But in my SQL db I have a "unique_identifier" field, which never changes, even when the user is changing his/her email address (due to marriage or the like). What I'd really like to do is to use %u to find the value of the