similar to: Different Collation (utf8_slovak_ci, utf8_danish_ci, latin1_german1_ci) etc.

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

I've looked over the docs on remote backends, the protocol, and a bit of the c++ for doing distributed and remote searches. I've got a couple of questions: * The remote protocol is usable only as a Database, not as a WriteableDatabase -- is this correct? So, if I don't want my application to have a copy of the database on the same machine I'll need to write an indexer daemon on

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:

[crossposted to -stable and -i18n, replies directed to -stable] Hi everyone, could someone point me to infos regarding Unicode collation support in FreeBSD? All I could find was https://wiki.freebsd.org/KonradJankowski/Collation but that page has not been changed in more than two years. Looking at sources of -current it doesn't look like those changes made it into the source tree yet.

Dear List, consider the following scenario: setClass(Class = "A", representation = representation(B = "B", C = "C")) setClass(Class = "B", representation = representation(C = "C")) setClass(Class = "C", representation = representation(something = "character")) Obviously, the collation for sourcing these defs needs to be: C,

The following caused a hard-to-diagnose problem for a user of the survey package. Presumably this is a strange Unicode thing, but is there a convenient reference for how the collation order is determined? I am surprised that adding the same character to the end of two strings of the same length can change the sorting order. in en_US.utf8 locale > "1//"<"10/" [1]

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

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

Boa tarde pessoal. Estou utilizando o intant rails com ruby v.1.8.6 e rails 2.0.2 com um servidor sqlserver2000, minha base de dados usa o collation SQL_latin1_general_CP1_CI_AS, quando tragos strings com acentuação e cedilha não consigo visualizar os carateres corretos, sei que para exibir corretamente o texto no ruby tenho que usar UTF-8. Como posso fazer pra mudar o collation da minha base ou

Hello, I want to change the connection collation that rails uses but I''m unsure of exactly what the best way to do this is. Everything in MySQL - the server, database and all tables are set to utf8_unicode_ci collation, but the connection collation in rails still appears to be utf8_general_ci (the default?). We are using the mysql2 adapter. I''ve seen a couple of possible

I'm happy to be able to announce that Xapian 1.3.4 is now available. Please note that 1.3.x releases are development releases - they are made to encourage earlier and wider use and testing of new and changed code. Our record with 1.1.x was very good - all the bugs I am aware of were either in new features, or were also present in the corresponding 1.0.x release. But if you main concern is

Is there a way to set the collation when creating a table in a migration? Thanks, Ricardo -- Posted via http://www.ruby-forum.com/.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have been moving printers from lpd printing to samba print queues. Drive installs, point-n-print, and everything else is working well but I can't for the life of me figure out how to make print job collate. I've been searching on how to correct this problem but have been unable to find anything. My setup is Samba 3.0.11 + 3.0.14a

Hi everyone, I am reconsidering how I am using the Puppet nagios functionality, at the moment I am creating one service for each check on each host. A lot of them are identical, and would be better tied to hostgroups to simplify my config. Namely, I have about 5,000 checks in there now which will go up to about 20K over the next month, and it''s taking about 5-10 minutes for a Puppet

Hi, We''re using Ferret in a slightly unorthodox way: We''re indexing a large (>100,000) list of names of places all around the world. Mostly we''re quite happy with it, and have been able to graft on our own particular required functionality with just a little tweaking. There''s one strange problem, though: We''ve got a place in Cyprus called

Hi, I''ve got an error when I upload a record by iPhone with Chinese character. Processing ScoresController#create (for 123.204.56.133 at 2009-08-04 16:19:52) [POST] Parameters: {"score"=>{"score"=>"79.60", "player_name"=>"一", "iphone_identifier"=>"6b194f783d645ba1a7c30c0e31b1b67300eb0a25"},

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

Hi, I'm using xapian with c# and mono and i'm having a segfault in get_weight. When i print the index variable, the value is clearly too high. I think something write over it. Do you have any idea on how i could trace the beginning of the segmentation fault ? Thanks, -- Yann

Hi all, I've tried building RPMs for RHEL5 and hit this problem in Search::Xapian: make test fails on test 37: ok 34 - check PositionIterator ok 35 - create TermIterator ok 36 - check TermIterator dubious Test returned status 0 (wstat 11, 0xb) DIED. FAILED tests 37-65 Failed 29/65 tests, 55.38% okay $ xapian-config --version xapian-config - xapian-core 1.0.4 $ cat

Hi all, I'm (still) need(ing) something like Solr[1] to Xapian, to make it I have 2 options, extend xapian-tcpsrv or re-implement ftss project[2], the problem of ftss is that it is 5 years old, and there's lots of changes into Xapian library (and also libc), what is the best way to implement a Solr-like server to Xapian? Did you done some progress Philip Neustrom? [1] -