Greg Hewett's Blog

Just a simple journal.

Migrating Redmine From MySQL to PostgreSQL

| Comments

First of all, I think that taps is one of the best tools to have in your pocket if you are doing anything with databases.

PGError: ERROR: invalid byte sequence for encoding “UTF8”: 0x95 PGError: ERROR: invalid byte sequence for encoding “UTF8”: 0x92

~~~ruby

!/usr/bin/ruby

require ‘rubygems’ require ‘mysql’

my = Mysql::new(“127.0.0.1”, “redmine”, “froUc6oagoaQiuwi1T”, “redmine_production”) res = my.query(“select id, description from issues order by id”) puts “=”*80 res.each do |row| if !row[1].scan(/\x92/).empty?

puts "#{row[0]}"
puts "#{row[1]}"

end end ~~~

Comments