mysql and database

This is a discussion on mysql and database within the Windows Programming forums, part of the Platform Specific Boards category; hi all,I have a question of my project!! I want to use mySQL with VB to develp a database. I ...

  1. #1
    frankiepoon
    Guest

    Red face mysql and database

    hi all,I have a question of my project!!
    I want to use mySQL with VB to develp a database.
    I want to the database including the customers photo.I don't know how to insert to the database.What is the type of the field that respresent the each photo ??
    Pls help me!!

  2. #2
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,859
    Try including all the photos as a seperate file.

    You can 'merge' them all into one big, say, .jpg and just store the offset and size. Then just open the big file, move to the offset and read for the size.

    Or can store the path to the photo as a field.

    Watch out as there is a finite limit to the number of files that can be stored in a single folder (only if you have excessive amounts of photos will this be a problem).
    "Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
    Friedrich Nietzsche

    "I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
    George Best

    "If you are going through hell....keep going."
    Winston Churchill

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. [C#] MySQl database problems
    By Jelte in forum C# Programming
    Replies: 5
    Last Post: 09-26-2008, 04:11 AM
  2. Replies: 1
    Last Post: 05-06-2006, 12:17 AM
  3. Problem connecting to MySQL Database?
    By MrLucky in forum C++ Programming
    Replies: 5
    Last Post: 01-30-2006, 11:30 AM
  4. About C++ and MySQL or oether free database
    By xxxrugby in forum C++ Programming
    Replies: 18
    Last Post: 12-30-2005, 06:28 AM
  5. Can i use the ASP to access MYSQL database??
    By Frankiepoon in forum Windows Programming
    Replies: 1
    Last Post: 10-15-2002, 03:37 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21