getting serialized data into and out of a database

[Gabriel Genellina]

En Mon, 29 Oct 2007 19:07:18 -0300, Michael Pelz Sherman  
<mpelzsherman at yahoo.com> escribió:

> I'm having a devil of a time getting serialized data into and out of a  
> database (MySQL in this case) using python and MySQLdb.
>
> I have some C code that has its own serialization/deserialization  
> functions, which we've wrapped using SWIG.
>
> I am able to save the serialized C structs to disk but when I try to  
> write the exact same data to MySQL and pull it back out, I'm getting  
> some strange results. The data comes back looking like this:
>
> array('c', '\x01r\x01\x00\x...)
>
> Is this a python buffer, or what? How can I access the data in there?  
> I've tried using [1] but that doesn't seem to work.

It's an array of characters <http://docs.python.org/lib/module-array.html>
You can write it to disk again using its tofile() method

-- 
Gabriel Genellina