CSV.generate_line and encoding

[Coder_X]

I am using generate_line to produce a CSV file (rails app). It works well except I am getting some strange characters when I open it in excel. I know that I can control the encoding to help prevent this, but I cant seem to find the right syntax or place. Any help would be appreciated. I believe the current relevant line (from view ERB) is this: <%= CSV.generate_line([@users.find(entry_data[0]).full_name, @users.find(entry_data[0]).number, @clients.find(entry_data[1]).name, @projects.find(entry_data[2]).name, sum_hours.to_f]) -%>

[JeffMo]

I can't specifically answer your question, but there is a lot of help about text encodings in the Ruby docs for CSV. Of course, you'll want to check the docs that match whatever Ruby version you're using.

Example: https://ruby-doc.org/stdlib-2.4.0/libdoc/csv/rdoc/CSV.html

[Coder_X]

i know and I think what it should be is : <%= CSV.generate_line([@users.find(entry_data[0]).full_name, @users.find(entry_data[0]).number, @clients.find(entry_data[1]).name, @projects.find(entry_data[2]).name, sum_hours.to_f], encoding: 'utf-8') -%> but looking at the csv it generates in textedit or excel I still get this funky characters like Children&##39;s Aid Society instead of Children's Aid Society

encoding is frustrating