Hi,
we're trying to use web2py to upload a binary file to a MySQL
database. After reading some examples we landed on this table
defenition:
ts_db.define_table('firmwares',
Field('file', 'upload', uploadfield='file_data'),
Field('file_data','blob', default=''),
Field('crc', 'integer'),
Field('softwareRevisions_id', 'integer'),
)
This works perfectly with SQLForms for uploads, but web2py seems to
store the file base64 encoded. Is there any way to avoid this? Since
the file is later fetched by another application it's a little extra
hassle to base64 decode the file. The best solution would be to tell
web2py to store the file in raw format.
Best regards
Fredrik
