Working with bytes.

[Piet van Oostrum]

>>>>> "Adam T. Gautier" <adam_gautier at yahoo.com> (ATG) wrote:

ATG> I have been unable to solve a problem.  I am working with MD5 signatures
ATG> trying to put these in a database.  The MD5 signatures are not generated
ATG> using the python md5 module but an external application that is producing
ATG> the valid 16 byte signature formats.  Anyway, these 16 byte signatures are
ATG> not nescarrally valid strings.  How do I manipulate the bytes?  I need to
ATG> concatenate the bytes with a SQL statement which is a string.  This works
ATG> fine for most of the md5 signatures but some blow up with a TypeError.
ATG> Because there is a NULL byte or something else.  So I guess my ultimate
ATG> question is how do I get a prepared SQL statement to accept a series of
ATG> bytes?  How do I convert the bytes to a valid string like:

ATG> 'x%L9d\340\316\262\363\037\311\345<\262\357\215'

ATG> that can be concatenated?

Depends what the database accepts. If it supports BLOBs you could use
that. Otherwise convert them to hex, or base64.
See for example the the codecs module or the binascii module.

-- 
Piet van Oostrum <piet at cs.uu.nl>
URL: http://www.cs.uu.nl/~piet [PGP]
Private email: P.van.Oostrum at hccnet.nl