gistfile1.rb

def convert_encoding(result)
  ["’", "’"].each do |quote|
    result.gsub!(quote, "'")
  end

  ["—", "―"].each do |mdash|
    result.gsub!(mdash, "—")
  end
  
  result.gsub!("…", "…")
  result.gsub!("â„¢", "™")

  ["“", "“"].each do |doublequote|
    result.gsub!(doublequote, "\"")
  end
  
  result
end

PagePart.all.each do |pp|
  pp.update_attribute(:body, convert_encoding(pp.body))
end

NewsItem.all.each do |ni|
  ni.update_attribute(:body, convert_encoding(ni.body))
  ni.update_attribute(:blurb, convert_encoding(ni.blurb))
end