Fixed handling of binary content in blobs and similar fields for Ruby/MySQL and SQLite #409 [xal]

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@309 5ecf4fe2-1ee6-0310-87b1-e25e094e27de

1 files changed, 23 insertions, 1 deletions

diff --git a/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb b/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb
index 604fc960aa..4dc8d634b3 100644
--- a/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb
+++ b/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb
@@ -25,6 +25,28 @@ module ActiveRecord
   end
 
   module ConnectionAdapters
+    
+    class SQLiteColumn < Column
+      
+      def string_to_binary(value)
+        value.gsub(/(\0|\%)/) do
+          case $1
+            when "\0" then "%00"
+            when "%" then "%25"
+          end
+        end                
+      end
+      
+      def binary_to_string(value)
+        value.gsub(/(%00|%25)/) do
+          case $1
+            when "%00" then "\0"
+            when "%25" then "%"
+          end
+        end                
+      end
+      
+    end
     class SQLiteAdapter < AbstractAdapter # :nodoc:
       def select_all(sql, name = nil)
         select(sql, name)
@@ -37,7 +59,7 @@ module ActiveRecord
 
       def columns(table_name, name = nil)
         table_structure(table_name).inject([]) do |columns, field| 
-          columns << Column.new(field['name'], field['dflt_value'], field['type'])
+          columns << SQLiteColumn.new(field['name'], field['dflt_value'], field['type'])
           columns
         end
       end