[Sqlrelay-discussion] Problem with Python cPickle and blobs

[Ville S. <vs...@eb...>]

Hi,

I'm using PySQLRClient from sqlrelay-0.36 (with rudiments-0.28.2)
to store blobs in Oracle 9.2.0 database.

I'm not sure if this has been fixed in the recent sqlrelay release,
but I'm experiencing problems when I store a Python data structure
(dictionary object) to a blob using Pythons cPickle module. Everything
works great until one of the values in the pickled object is an empty
string (''). After that cPickle.load fails to read the data, it raises
EOFError exception. So I wonder if PySQLRClient interprets the pickled
'' as an end-of-file character?

If I try loading/saving similar data structure to a file, it works ok.

Thanks for any advice,

Ville