Forum: Ruby on Rails [maybe ot] Special Characters in DB Fields

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Ef0db53920b243d6758c2f6b1306df0d?d=identicon&s=25 Steve Ross (cwd)
on 2006-04-15 23:10
(Received via mailing list)
I have MySQL on a Linux (RH) server and Mac OSX. I did a mysqldump on
the
Linux box and imported it into the database on the Mac. The following
text
is in one of the fields:

Maui�s Westin Ka�anapali

This is supposed to read

Maui's Westin Ka'anapali [note: straight quotes shown here are really
apostrophes]

In fact, it renders properly when served up from the Linux box (Safari
client). Served up from the OSX box, it doesn't. All encoding is utf-8,
database, page, everything.

I even have the following in application.rb:

  before_filter :set_charset

  # ... stuff ...

  private
  def set_charset
		@headers["Content-Type"] = "text/html; charset=utf-8"
  end

Questions: Has anyone had this problem (or the related black diamond
with a
question mark); and is there a known cause/fix?

Thanks
--
View this message in context:
http://www.nabble.com/-maybe-ot-Special-Characters...
Sent from the RubyOnRails Users forum at Nabble.com.
This topic is locked and can not be replied to.