# Binary data on SQLite adaptor is not properly escaped?

**URL:** <https://www.ruby-forum.com/t/binary-data-on-sqlite-adaptor-is-not-properly-escaped/133178>\
**Category:** Rails\
**Created:** [March 28, 2008, 3:57pm UTC](https://www.ruby-forum.com/t/binary-data-on-sqlite-adaptor-is-not-properly-escaped/133178 "2008-03-28T15:57:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![benhiller](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/8e7dd6/32.png) [@benhiller](https://www.ruby-forum.com/u/benhiller)\
**Post date:** [March 28, 2008, 3:57pm UTC](https://www.ruby-forum.com/t/binary-data-on-sqlite-adaptor-is-not-properly-escaped/133178/1 "2008-03-28T15:57:06Z")

</div>

I’m problems that seem to indicate that binary data is not properly  
escaped by the SQLite adaptor. I haven’t tested any other adaptors. Is  
this a known issue?

My code looks something like this:

create\_table :mytab do |t|  
t.column :mybin, :blob  
end

class MyTab \< ActiveRecord::Base  
end

# Boom!

MyTab.new( :mybin =\> Base64.decode64( ‘AiEQ3um3AC8KMF  
+FOMV4CYp0T18=’) ).save!