CSV writing Ruby Encoding Error

Question

I am trying to write a UTF-8 character in a CSV file with csv library of Ruby. And I have got an error:

csv ruby write problem ASCII-8BIT (Encoding::CompatibilityError)

#create csv file
CSV.open(CSV_file,"wb",) do |csv|
  csv << First_line
  rows.each do  |r|
    csv << r.generate_array
  end
end

That's the code where UTF-8 conflicts with ASCII-8BIT.

Example text that fails:

demás

ruby 2.3.4p301 (2017-03-30 revision 58214) [x86_64-linux-gnu] Ubuntu 16.04 uname -r 4.10.0-28-generic — kahonmlg
r is a class called CSV_row that I have create. They are objects generated in the same script. Taking data from others files, and generating a object with text information that will be inserted to the CSV. — kahonmlg
If you write utf-8, why not use CSV.open(CSV_file,"w:utf-8"? YOur example can't be used to show details. E.g. what is rows in your code? — knut

dawg dawg · Accepted Answer · 2017-07-30T20:16:43

Here is an example of CSV writing and reading with UTF-8:

fn="/tmp/f.csv"

require "csv"
d1=DATA.read.split(/\n/).map {|e| e.split}
CSV.open(fn, "w:utf-8") do |row|
   d1.each { |dr| row << dr }
end

d2=[]
CSV.foreach(fn) do |row|
  d2 << row
end

puts d1==d2
# true

__END__
privé face à face à un tête-à-tête
Face to face with one-on-one
demás

Without a more detailed example from you, I cannot help further.

CSV writing Ruby Encoding Error

1 Answers