[maybe ot] Special Characters in DB Fields


#1

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.