Toby Rodwell wrote: [...] > Many thanks for the reply Matt. I used the console to determine that > the db is serving up ASCII-8BIT > >>>e = Equipment.find(:first, :conditions => ['id = ?', 1234]) >>> e.name.encoding > => #<Encoding:ASCII-8BIT> > > I then set the encoding in /config/database.yml to 'ascii' which > although it can't display special characters, at least it shows the page > with "?" in place of the accented charaters. I tried setting encoding > to "ascii-8bit" and varieties of this, but each time Rails complained - > so if anyone can tell me how to indicate ASCII-8BIT I'd be grateful.
This doesn't solve your immediate problem, but...if your host locks the DB in ASCII 8-bit and you can't change it, then find a new host. That encoding is inappropriate for real work. :) Best, -- Marnen Laibow-Koser http://www.marnen.org mar...@marnen.org -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---