mysql_repro.rb

require 'rubygems'
require 'active_record'

`/usr/local/mysql/bin/mysql -u root unicode_test < create_test_db.sql`

ar_confs = {
  "mysql" => {
    "adapter" => "mysql2",
    "database" => "unicode_test",
    "username" => "root",
    "password" => "",
    "socket" => "/tmp/mysql.sock"
  },
  
  "mysql2" => {
    "adapter" => "mysql2",
    "database" => "unicode_test",
    "username" => "root",
    "password" => "",
    "socket" => "/tmp/mysql.sock"
  }
}

ActiveRecord::Base.configurations = ar_confs

class UnicodeTestMySQL1 < ActiveRecord::Base
  set_table_name "unicode_tests"
end 

class UnicodeTestMySQL2 < ActiveRecord::Base
  set_table_name "unicode_tests"
end

UnicodeTestMySQL1.establish_connection "mysql"
UnicodeTestMySQL2.establish_connection "mysql2"

unicode_str = %Q[Σαλάτα με καρπούζι και]

puts "Writing #{unicode_str} into DB using mysql1"
mysql1 = UnicodeTestMySQL1.new
mysql1.col_varchar = unicode_str
mysql1.col_text = unicode_str
mysql1.save

mysql2 = UnicodeTestMySQL2.find(:last)
puts "Reading #1 varchar = #{mysql2.col_varchar}, text = #{mysql2.col_text} using mysql2"