MySQLdb blob and binary data
Denis S. Otkidach
ods at strana.ru
Fri Dec 10 13:08:03 EST 2004
On Fri, 10 Dec 2004 16:58:56 +0100
Rune Hansen <rune.hansen at scanmine.com> 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
GzipFile(fileobj=StringIO(data)).read()
--
Denis S. Otkidach
http://www.python.ru/ [ru]
More information about the Python-list
mailing list