Getting test fixture binary files stored in DB

rubyonrails-talk
1

Hi,

db_files is a table that contains binary data. I'm using postgresql 8.1 if it matters. I want to get some binary data into the fixtures that gets loaded into the test database.

Here's my fixture:

<% require 'base64' %> picture_original:   id: 1   data: <%= Base64::encode64(File.read('/home/joe/gof21.jpg')).gsub("\n","").gsub(/\s+/, '') %>

It works with no errors, but the data that gets put into the database is corrupted. Any ideas?

Thanks, Joe