utf8

gistfile1.txt

  def self.make_utf8_clean
    mappings = [  ['α', 'α'],
                  ['ß', 'β'],
                  ['β', 'β'],
                  ['’', '’'],
                  ['“', '“'],
                  ['â€\u009D;', '”'],
                  ['â€', '”'],
                  ['ö', 'ö'],
                  ['®', '®']
              ]
    # Get the list of String columns
    columns = Array.new
    self.columns.each do |column|
      if column.type.to_s == 'string' || column.type.to_s == 'text'
        columns << column
      end
    end

    # Go through each object -> column against all mappings
    self.all.each do |obj|
      columns.each do |column|
        mappings.each do |mapping|
          value = obj.attributes[column.name]
          if value =~ /#{mapping[0]}/
            s = value.gsub(/#{mapping[0]}/, "#{mapping[1]}")
            obj.update_attribute(column.name.to_sym, s)
          end
        end
      end
    end
  end