similar to: Copyright (c) symbol, mysql and utf8

I have Rails 1.1, MySql 5.0 and would like to stor text as utf8 in the db. I have changed the character set and collation in the db to utf8 and utf8_danish_ci - also checked the mysql to if its ok: show collations like "%danish%"; utf8_danish_ci utf8 203 Yes 8 I then add the following environment.rb: $KCODE = ''u'' require ''jcode'' och database.yml

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]

On 13/08/2015 15:19, peter dalgaard wrote: > Yes, collation is a strange thing, and? And remember that on some platforms (including yours) ICU is used, so LC_COLLATE is not particularly relevant (unless it is 'C'). See ?Comparisons and ?icuGetCollate. E.g. on my Yosemite system in en_US.UTF-8 > rank(c(x, y)) [1] 1.5 1.5 > icuGetCollate() [1] "root" >

Yes, collation is a strange thing, and? Collation order will depend on locale settings, and there are quite a few cases where the collation order of two items is not defined. To add to the confusion, on OSX Mavericks, I see > x <- "\u0663" > y <- 3 > > x == y [1] FALSE > rank(c(x, y)) [1] 2 1 > x [1] "?" > x == y [1] FALSE > x > y [1] TRUE

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:

Hello, I am having this mysql error in my ruby on rails application. ActiveRecord::StatementInvalid occurred in > event#lg: > Mysql::Error: Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for > operation ''='': select * from locations where country = ''HU'' and > geo_state = ''08'' and city

Hi, Creating a new Rails application with -d postgresql sets the encoding in the database.yml to unicode Creating a new Rails with -d mysql sets the encoding to utf8 Any ideas why this difference? I''ve been having problems with encoding due to localization, accents, json and what no. I thought I was using utf8 and not unicode. Would this have any impact? If this would be an issue?

In particular, if you''re putting Rails on Snow Leopard to work on a project that you started on Linux. If you run rake db:create and see an error like this: Couldn''t create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql",

Hi, Our public library management software (PMB) is currently running on a Slackware Linux 12.0 server, with Apache, PHP, MySQL and a few PHP modules. I'm considering migrating it to CentOS 5.1, because it would be easier to maintain for updates, and for various other reasons. Slackware is one of the rare distros that does not default to an utf8 system locale. The default is en_US, and

Not sure if this is off topic, but there doesn''t seem to be an obvious place to ask this question. I am trying to use MacPorts to install mysql. I have xcode 3.0 and x11 XQuartz 2.1.6 installed. $PATH: /opt/local/bin:/opt/local/sbin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/ local/bin:/usr/X11/bi When I sudo port install mysql5-server I receive: ---> Configuring mysql5 Error: Target

Hi all According to the Agile 2nd Ed book I added the line encoding: utf8 to my database.yml connections. But now when running rake I get plenty of errors: Character set ''utf-8'' is not a compiled character set and is not specified in the ''/usr/local/mysql/share/mysql/charsets/Index'' file What''s wrong here? I checked this Index file, but it seems to

Since upgrading to Rails 1.2.* my ActiveRecord has not been acting properly: When I perform a .find and give a UTF8 string as a conditional, the select statement gives me the following: SELECT * FROM albums WHERE (name = ''Medúlla'') When I perform a .save on a model UTF8 and other characters ( . ! ) get stripped out of the query: INSERT INTO albums (`name`)

On Sat, Nov 22, 2014 at 12:42 PM, Duncan Murdoch <murdoch.duncan at gmail.com> wrote: > On 22/11/2014, 2:59 PM, Stuart Ambler wrote: >> A colleague?s R program behaved differently when I ran it, and we thought >> we traced it probably to different results from string comparisons as >> below, with different R versions. However the platforms also differed. A >>

Hi Using ruby 1.8, rails 1.0, mysql 4.1.11 in database.yml: adapter: mysql encoding: utf8 database: myproject_development username: user password: password socket: /var/run/mysqld/mysqld.sock but when I start the error I get: Can''t initialize character set utf8 (path: /usr/share/libmysqlclient/charsets/) Can anyone tell me what file it''s looking for, and how I

If you use ActiveRecord::Base.connection.create_database you''ll notice that by default the created db will use latin1 encoding. I created a plugin to handle different charset and collations (on top of helping you with other boring DB tasks). You can check out the early version of the plugin svn checkout svn://rubyforge.org/var/svn/raketasks/db_tasks (I really need to move my projects out

https://bugzilla.mindrot.org/show_bug.cgi?id=3168 Bug ID: 3168 Summary: libssh.a(utf8.o): undefined reference to symbol 'strcasestr@@GLIBC_2.17' Product: Portable OpenSSH Version: 8.2p1 Hardware: ARM64 OS: Linux Status: NEW Severity: critical Priority: P5

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

> On 23 Nov 2014, at 01:05 , Henrik Bengtsson <hb at biostat.ucsf.edu> wrote: > > On Sat, Nov 22, 2014 at 12:42 PM, Duncan Murdoch > <murdoch.duncan at gmail.com> wrote: >> On 22/11/2014, 2:59 PM, Stuart Ambler wrote: >>> A colleague?s R program behaved differently when I ran it, and we thought >>> we traced it probably to different results from

For many scientific applications one is really dealing with ASCII characters and LC_COLLATE="C", even if the user is running in non-C locales. What robust approaches (if any?) are available to write code that sorts in a locale-independent way? The Note in ?Sys.setlocale is not overly optimistic about setting the locale within a session. Martin Morgan On 11/23/2014 03:44 AM, Prof