CODEWITHSUNDEEP
excelpython-3.xpostgresqlzip
Gabriel
Gabriel

Reputation: 624

Zip file to bytes Python 3

I want to store a zip file in a postgres database. The column is type bytea

When attempting to get the bytes of a json file, or a csv file I can use this

with open(filename, encoding='utf-8') as file_data:
    bytes_content = file_data.read()

However, if I try a zip file, or even an xls file I get an error. 

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd7 in position 14: invalid continuation byte

I did some searching and it was suggested to change to encoding type, I've tried latin-1 and ISO-8859-1, both of which gives me an error. 

ValueError: A string literal cannot contain NUL (0x00) characters.

Any idea as to how to get the bytes of a zip file so I can store it in a postgres database?

Upvotes: 6

Views: 16126

Answers (1)

blhsing
blhsing

Reputation: 106553

If you want to read the JSON file as bytes you should open the file in binary mode:

with open(filename, 'rb') as file_data:
    bytes_content = file_data.read()

Upvotes: 10

Related Questions