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-in-DB-Fields-t1455759.html#a3934248
Sent from the RubyOnRails Users forum at Nabble.com.