similar to: UFT8 String looks great in MySql, garbage in browser

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]

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

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''ve just moved a rails site across to a test server from my development PC. I''ve frozen rails and put all the relevant gems into the vendor/gems directory too. I''ve migrated the mysql database and configured Apache with Phusion Passenger. I can access the site and the content is fine. The formatting however, has disappeared - it''s as though the css file does

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

My app has a stylesheet that includes this definition: div.loadimage { width:580px; height:310px; background-image: url("/images/load.gif") no-repeat center 0% 0%; } The purpose is to use with some nice javascript by Patrick H. Lauke for fading in images. The div is supposed to include a "loading image" image which is overwritten by the final image when it has finished

Does anyone know a good authentication tutorial they can suggest? I''ve tried several restful authentication ones and an authlogic one on RailsCast. But with each one I try, something seems to be missing in the tutorial and I can''t get it to work. I''m new to Rails so it''s possible user error on my part. I''m on Mac OS X 10.5 and I generate all my apps in

I am using JRuby and I have to deploy on Tomcat. My web app is working fine in the dev envirmonment, with Mongel, but when I deploy on Tomcat I get "We''re sorry, but something went wrong on Tomcat". The problem is that production.log only shows: # Logfile created on Mon Oct 12 12:54:36 +0100 2009-bash-3.00 The file permission and directory are 777. Any idea how I can

Hey everybody, I''m trying to make an example of a small networking site, and when I log in a user, it should redirect and show his profile, but I get the following error: NoMethodError in User#index Showing app/views/user/index.html.erb where line #5 raised: undefined method `screen_name'' for nil:NilClass Extracted source (around line #5): 2: Your basic information 3:

Hello, I''ve been trying for hours to parse an XML using Hpricot. Usually it''s not a problem. Here''s my simple code: #This works and outputs the proper xml data @url1 = ''http://www.sportingnews.com/stories/sportingnews/MLB/rss.xml'' @page1 = Hpricot(open(@url1)) <%= @page 1 %> #This does not work, and I''m scratching my head @url1 =

Just wanted to see if I was using the latest acts_as_solr plugin, but the URL <http://acts_as_solr.railsfreaks.com/> takes me to a GoDaddy domain parking page. Anyone know what''s happened to railsfreaks, and more particularly this plugin? -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org twitter: @hassan -- You received this

I''ve got a web-app currently partially working. The user uploads a .txt, .docx or .doc file to the server. Currently the model handles those files, saves some metadata (the extention and orig filename) then saves the file to the hard drive. Next it converts the doc and docx files to plain text and saves the output to a txt file. My problem is I want to copy the plain text contents of

Hi Everybody, Greetings!! I want to use rspec for my applications. Please guide me with the Rspec tutorial. I want a good example to start with. Please help me by providing good tutorials on Rspec to start with. I actually followed the example from http://rspec.info Please guide me on more examples. Waiting for your reply. --~--~---------~--~----~------------~-------~--~----~ You received

Hello, I cannot find the issue and it drives me crazy :( let''s simplify. I have 2 models: saving and purchase_type a *saving* corresponds to a *purchase_type* e.g. new sourcing or renegotiation a saving has exactly one purchase_type and a purchase_type has many savings. when I try to display the list of savings and their purchase type (name, not Id), i get the dreaded "You have a

I''ve setup two models, 1 and 2, that are associated by has_and_belongs_to_many. I''m trying to get an attribute from model_1 to use in a method in model_2. When I use the code below, I get an error saying ''undefined method model_1_id''. What am I missing? Thanks! Model_2.rb Class Model_2 < ActiveRecord::Base ... has_and_belongs_to_many :model_1 def

I am creating a rails app that is a gui wraping a restful web service that uses a websso for authentication. This websso sets a series of headers that I need to pass from the request to the ActiveResource.find methods. As this is stuff like username etc it is going to be different for each request. I can find examples on how to set headers for all requests not just one. Does anyone know of a way

I''ve created a table in a SQL Server database using a migration, successfully. I''ve tried to change the name of a column in the table and got the error message above when running ''rake db:migrate''. Previously I have developed using MySQL and Sqlite and migrations have worked successfully. This is an error I have not seen before. Has anybody seen this and worked

Hi All, Rails code must be readable, formatted and well indented. I wanted to do indent code in my previous projects. Is there any built in rails plugin/gem that can help me to indent my existing code. Any ideas will be really appreciated ! NOTE: Please don''t suggest editor plugins. Thanks & Regards, Sandip R~ -- Ruby on Rails Developer http://sandip.sosblog.com

Hi, Using Netbeans 6.7.1, Rails Gem Version 2.3.2 MySQL Server 5.1 I am currently doing the depot application from the pragmatic programmer book (agile web development with rails) everything has been fine up until the point of creating sessions. I know they are using an earlier version of Ruby and the gems version is 2.2.2. As soon as I put the necessary code in the website no longer works and

Hey guys, As most of you know, Rails 3.1 introduces query caching for ActiveRecord. Great change all-in-all, but for those of us with IT department mandates for using MySQL (yeah, yeah, I know...), it''s kind of a mixed bag. I need to disable query caching in a project I''m building based on 3.1. I''ve tried a couple different approaches, both without any success. I