Can I pickle a python dictionary into a sqlite3 text field?

pdata = cPickle.dumps(data, cPickle.HIGHEST_PROTOCOL)
curr.execute("insert into table (data) values (:data)", sqlite3.Binary(pdata))

curr.execute("select data from table limit 1")
for row in curr:
  data = cPickle.loads(str(row['data']))

#  register the "loader" to get the data back out.
sqlite3.register_converter("pickle", cPickle.loads)

p_string = p.dumps( dict(a=1,b=[1,2,3]))
conn.execute('''
   create table snapshot(
      id INTEGER PRIMARY KEY AUTOINCREMENT,
        mydata pickle);
''')

conn.execute('''
    insert into snapshot values
    (null, ?)''', (p_string,))
''')

query = u'''insert into testtable VALUES(?)'''
b = sqlite3.Binary(binarydata)
cur.execute(query,(b,))
con.commit()