#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    4
    Rep Power
    0
    Is it possible in MySQL to store jpg images as a field in a table? If so, how? What datatype should I use?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    7
    Rep Power
    0
    use BIN because it is a binary file....
    http://mysql.com

    hope that helps
    ccbcreg

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by kay:
    Is it possible in MySQL to store jpg images as a field in a table? If so, how? What datatype should I use?[/quote]

  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,646
    Rep Power
    4492
    You mean BLOB? There's no datatype of BIN.
    http://www.mysql.com/documentation/m...l#Column_types

    ---John Holmes...
  6. #4
  7. Lurker - in your bushes
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Location
    .be
    Posts
    494
    Rep Power
    117
    Just my 2cents, but you'll be much better off if you only use references to JPG files saved somewhere...instead of going through BIN etc...

Similar Threads

  1. Can't move or delete it!
    By Hykinsel007 in forum Windows Help
    Replies: 3
    Last Post: June 15th, 2004, 04:41 PM
  2. Previewing uploaded files before storing
    By rodina in forum PHP Development
    Replies: 0
    Last Post: January 15th, 2004, 02:33 AM
  3. Too many files hurts performance?
    By ace2600 in forum BSD Help
    Replies: 4
    Last Post: January 11th, 2004, 03:12 PM
  4. how to rename files
    By dxgn in forum Perl Programming
    Replies: 1
    Last Post: January 1st, 2004, 02:10 PM
  5. How can I pack servlet files into a jar file?
    By suryahema in forum Java Help
    Replies: 1
    Last Post: December 18th, 2003, 09:32 AM

IMN logo majestic logo threadwatch logo seochat tools logo