similar to: ActiveRecord::Base.connection.create_database defaults to latin1

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 have built a project with Instant Rails.Now only a database and a scaffold based on a product model have finished.But when i inputted "../admin/list" in my browser,i found my chinese characters cound not display normally.Then i made five steps: 1 ajusting encoding in my browser menu 2 in "C:\InstantRails\conf_files\my.ini"directory,making sure

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

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 I noticed that if in my code I use the following: Photo.update_all("title = ''Ruby rocks'' ", "id IN (#{@photo_ids})") All my objects are properly updated but none of the filters/callbacks are triggered. Is that what''s expected? I have a before_update filter set on the Photo class and it gets totally ignored, I guess the only way to solve this

Hi, I''ve been looking for a light weight alternative to rails for a few small projects, and just came across merb, which looks perfect. The only issue is that merb seems to be tied to mongrel, and I have to deploy to our internal infrastructure which uses FastCGI. How difficult would it be for me to modify merb to support a fcgi interface (actually a rack interface - rack is

Hi everyone! I think I stumbled over a bug in the latest R 2.9.2 patched for OS X: > R version 2.9.2 Patched (2009-09-24 r49861) > i386-apple-darwin9.8.0 When I try to sort latin1-encoded character vectors, R sometimes crashes with a segmentation fault. I'm running OS X 10.5.8 and have observed this behaviour both with the i386 and x86_64 builds, in the R.app GUI as well as on

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

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

I am switching to a composite primary key (string and user ID) from the Rails conventional auto-incrementing integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

I thought you might be interested in how far I have got with solving my problem with MySql(via phpMyAdmin) to website character_set problems. I thought I had solved the problem when my characters on my website started showing the special characters. This was a partial success though. When I went back to phpMyAdmin and entered new text the problem was the same, but reversed. What now happens is

Link was 404 :-( the correct link is http://21croissants.blogspot.com/2007/06/rspec-changes-log-rss.html I should definitely switch from blogger to mephisto ... Hi, As I am not a big fan of mailing list, I have created a Yahoo!Pipes to generate a RSS from the user & developpers mailing list and integrated it into a netvibes tab. I have also put a few blogs from the rspec authors. More

As we all know it, Time Zones are a pain in the neck. Rails make things easier by providing some nice helpers. However, I recently faced a challenge when trying to pre select a time zone for a user. Using the time_zone_select helper, there''s simply no way you can pre select a timezone for a user unless you already saved the time zone in his/her record. Creating a new user or editing a

Hi R developers, There seems to be breaking change in base::order on Windows in R-devel. Code below yields different results on R 4.0.0 and R-devel (2020-05-22 r78545). I haven't found any info about that change in NEWS. Was the change intentional? Sys.setlocale("LC_CTYPE","C") Sys.setlocale("LC_COLLATE","C") x1 = "fa\xE7ile" Encoding(x1) =

Ezra, * test harness in new generated merb apps with helpers for testing merb without starting a server. * pin down plugin arch Seems to me that these two tasks go together unless you want to have rspec built in Merb. Regarding the test harness, my understanding is that: - a developer should be able to easily write specs against a merb application. - a developer should not need to start a merb

Upon further inspection, I think these are at least two problems. First the issue with printing latin1/cp1252 characters in the "80" to "9F" code range. x <- c("?", "?", "?") Encoding(x) print(x) I assume that these are Unicode escapes!? (Given that Encoding(x) shows "latin1" I'd rather expect latin1/cp1252 escapes here, but

Thank you!. My apologies again for not including the console output in my message before. I sent another e-mail with the output in the meantime, so it should be a bit clearer now, what I am seeing. In case I missed something, please let me know. Yes, I am using latin1 and cp1252 interchangebly here, mostly because Encoding() is reporting the encoding as "latin1". You presumed correctly

This is a follow-up on my initial posts regarding character encodings on Windows (https://stat.ethz.ch/pipermail/r-devel/2017-August/074728.html) and Patrick Perry's reply (https://stat.ethz.ch/pipermail/r-devel/2017-August/074830.html) in particular (thank you for the links and the bug report!). My initial posts were quite chaotic (and partly wrong), so I am trying to clear things up a

Dear colleages in R, I have earlier been working with R in Linux, where reading in a table containing Scandinavian letters ("?", "?", and "?") in the header as part of variable names has not caused any problem whatsoever. However, when trying to do the same in R running on new MacOS-X (with an Intel processor) with the same original text table does not seem to