adodbapi / string encoding problem

Peter Otten __peter__ at web.de
Thu Sep 25 12:14:46 EDT 2003


Achim Domma wrote:

> BTW: How would you save binary data in an Access database? Access knows
> only Memo fields or am I wrong?

CREATE TABLE Bogus (TheFile BINARY);

might do to create the "Bogus" table with a binary "TheFile" field. 
As of Access 2000, I think the BINARY datatype is not exposed in the table
designer, so you have to type the SQL into the query designer and then
execute the query.

I have never used it, so the above might or might not work.

Peter




More information about the Python-list mailing list