User sign-up, adding image to db??

[titbread]

Hi, I'm making a user system for my site, and i wanna have a picture for the users profile..and i wanna do all this wiv a mySQL db. I don't know what type of field in my db's table i should use? varchar? Anyone know??

If anyone has any more info to look out for with this, please can u tell.. thanks!!

[cassius]

I don't know if I actually support your idea of storing all your userimages in your database(unless you know there are going to be few users with smaaaallll images) because this can slow down your application and make your DB very big...

If you're still going to do it this way , you would have to use som sort of BLOB-fieldtype(ex. MEDIUMBLOB or BLO😎 to store the images in your DB. Alternatively you could store the images on your server, and have a table in your DB with info about each user's picture....which is a solution I'm using on a couple of different web-applications with registred users

[helz]

for images, you only put the url of the image into the db, whether it be local or not, so it could be like:

/image/test1.jpg
http://www.domain.com/test1.jpg

i usually just use text for that. will have to do research on the different mysql table field types

[Benbread]

your name looks rather similar to mine :s