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

    Join Date
    Aug 2000
    Location
    chennai, tamil nadu, INDIA
    Posts
    27
    Rep Power
    0
    i want to store more than 10000 character with picture in my database. which datatype supports this facility?
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,646
    Rep Power
    4492
    I think you'd have to store the characters in one column, the image in another column. A BLOB field should handle both of them.

    For what it's worth, I don't store the actual picture in the database. I just make a text field and store the path to the picture. It seems too cumbersome to actually store the picture data and I don't see any benifit.

    ---John Holmes...

Similar Threads

  1. Best way to store data
    By valensnow in forum MySQL Help
    Replies: 0
    Last Post: February 16th, 2004, 10:39 PM
  2. Replies: 5
    Last Post: January 22nd, 2004, 05:38 PM
  3. Randomising picture placement
    By Chewie in forum PHP Development
    Replies: 3
    Last Post: January 20th, 2004, 07:28 AM
  4. uploading a picture
    By PimpedEclipse96 in forum PHP Development
    Replies: 1
    Last Post: January 19th, 2004, 01:36 PM
  5. creating database & tables using ASP
    By pdxlooie in forum ASP Programming
    Replies: 2
    Last Post: December 26th, 2003, 05:27 PM

IMN logo majestic logo threadwatch logo seochat tools logo