Redmine

Sorry, in description "postgresql 8.4.11".

Patch is (in attachment):

commit b0ec4111730809bc2f4bafd071ba2271e290e9e1
Author: Alex Eagle <eagle.alex@gmail.com>
Date:   Tue Apr 3 11:58:05 2012 +0400

    Force encoding string from data binary always (not only compressed)

diff --git a/app/models/wiki_content.rb b/app/models/wiki_content.rb
index 430e9a5..d5a3870 100644
--- a/app/models/wiki_content.rb
+++ b/app/models/wiki_content.rb
@@ -91,14 +91,16 @@ class WikiContent < ActiveRecord::Base
     end

     def text
-      @text ||= case compression
-      when 'gzip'
-        str = Zlib::Inflate.inflate(data)
+      @text ||= begin
+        str = case compression
+              when 'gzip'
+                Zlib::Inflate.inflate(data)
+              else
+                # uncompressed data
+                data
+              end
         str.force_encoding("UTF-8") if str.respond_to?(:force_encoding)
         str
-      else
-        # uncompressed data
-        data
       end
     end

It seems acts_as_versioned or PostgreSQL problem.

Not PostgreSQL exactly.
DB return byte-array. Rails interpretate column (t.column :data, :binary) in string context as ASCII-8BIT unless otherwise.
Соde for transformation field 'data' into text defined in WikiContent::Version#text.
IMHO, this is model Version problem.

Might be tied to #6941; I just saw I had this old issue back and that upgrading pg gem to latest version in Gemfile (+bundle update) solved it.

Updated pg gem to pg (0.13.2) do not solve it.

$ cat Gemfile|grep pg
    gem "pg"#, "~> 0.9.0" 
$ cat Gemfile.lock|grep pg
    pg (0.13.2)
  pg

Result:

>> WikiPage.first.content.versions.last.data.encoding
=> #<Encoding:ASCII-8BIT>