fix pysqlite2 support for the buffer type

1 files changed, 6 insertions, 0 deletions

diff --git a/db.py b/db.py
index c67cd21..2c40a94 100644
--- a/db.py
+++ b/db.py
@@ -357,6 +357,12 @@ class _PySqlite2Adapter(DBAPIAdapter):
             return
         sqlite._lc_initialized = 1
 
+        # XXX not clear why this is necessary while buffer (aka self.Binary)
+        #     is pysqlite2 default binary type....
+        def adapt_buffer(buffer):
+            return str(buffer)
+        sqlite.register_adapter(self.Binary, adapt_buffer)
+
         # bytea type handling
         from StringIO import StringIO
         def adapt_bytea(data):