On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote:
> Thanks Todd and Tyler for the encouragement,
>
> When I searched on Mysql column types, I did not find any obviously
> suitable for images.  I do not suppose I can use VARCHAR, can I?

Use one of the BLOB types.

Note that if you are running a web server, you might be better off just 
storing a path and filename in the database and have apache serve the image 
itself.

> Also, I need to have very good performance on data retrieval and transport,
> which means I also need to have maximum retrieval speed and minimun memory
> size of my images.  My images are just plain graphics, no rich colors. How
> can I realize the above purposes?

Photographic images should normally be stored as jpegs, line-art drawings as 
png.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to