Python. What is the correct way to store a pickle object in Mysql?

Question

Django

I'm trying to store a packed pickle object in MySql:

message = pickle.dumps(u'\xe7')<br>
MyModel(message=message).save()<br>

I get Warning: Incorrect string value: '\xE7\x0Ap0\x0A.' for column 'message'
We managed to find solutions: and
message = pickle.dumps(u'\xe7').decode('base64')

from django.utils.encoding import smart_str<br>
message = pickle.dumps(smart_str(u'\xe7'))

But it seems to me that there is a better solution to save objects containing strings like u'\xe7'

Answer 1

I have a feeling the problem here is a bit different. docs.python.org/2/howto/unicode.html

Answer 2

As an alternative, make the field in the database binary (for example, BLOB).

Answer 3

unearth django.contrib.sessions