[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: binary content in mysql



Jonathan Daugherty wrote on Mon Jul 16, 2001 at 12:09:14AM:
> 
> Is it possible to store binary data (say images or .doc files) in a
> mysql database?  If so, how?

Binary Data can be stored in Binary Table Fields: CHAR BINARY,
VARCHAR BINARY, TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB. You should think
about this twice, however, because with MySQL storing your binary data
in the filesystem and only references to that data in the database can
be more efficient.

Matth¡as
-- 
Matthias Richter --+- stud. soz. & inf. -+-- http://www.uni-leipzig.de
-->    GPG Public Key: http://www.matthias-richter.de/gpg.ascii    <--

· Projekt Deutscher Wortschatz: <URL:http://wortschatz.uni-leipzig.de>

Attachment: pgpLGHFAGN3kD.pgp
Description: PGP signature


Reply to: