[Tutor] string pickling and sqlite blob'ing

[Dinesh B Vadhia]

I want to pickle (very long) strings and save them in a sqlite db.  The plan is to use pickle dumps() to turn a string into a pickle object and store it in sqlite.  After reading the string back from the sqlite db, use pickle loads() to turn back into original string.  

- Is this a good approach for storing very long strings?  

- Are the pickle'd strings stored in the sqlite db as a STRING or BLOB? 

Cheers.

Dinesh

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20090624/aeec3408/attachment.htm>