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 ~~~