Hi.

If you want to store the binary images in the database, the column type will
most likely be a BLOB assuming the images are not bigger that 60k.
If you want to store just url or file paths (http://www.myhost.com/pict.jpg
or /home/bob/image.gif) use a VARCHAR(XX) where XX is a reasonable length of
what you think the longest link will be. 30? 50?

Have fun.

-ravi.

-----Original Message-----
From: Mike Baerwolf [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 4:02 PM
To: [EMAIL PROTECTED]
Subject: column types


Hello,

Just starting out with MySQL.  I like to put images or links to images in a
database, Is this possible?  If so what would be the column type be?

Thanks for the help
Mike


---------------------------------------------------------------------
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