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!!
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).