MySQLdb blob and binary data

Denis S. Otkidach ods at
Fri Dec 10 19:08:03 CET 2004

On Fri, 10 Dec 2004 16:58:56 +0100
Rune Hansen <rune.hansen at> wrote:

> I'm storing gzipped data in a MySQL blob field. I can fetch the blob and 
> "wb" write the data to a file. It becomes a file containg gz data.
> I can't take the same data and do anything sensible with it in python - 
> like say zlib.decompress(data).
> How can I convert the binary data from the blob field to the gzipped 
> string it was stored as (java stores the string, Pickle is not an option)?

You can pass any file-like object to GzipFile class:

from gzip import GzipFile
from cStringIO import StringIO

Denis S. Otkidach      [ru]

More information about the Python-list mailing list