A question..how can we store our nose and ear in data base??

[Gangotri]

A question..how can we store our nose and ear in data base??
plz reply.

[pixelsoul]

Sure.

INSERT INTO funny_people (nose, ear, brain)
VALUES ("Gangotri troll nose", "Gangotri hairy ear", NULL);

[Gangotri]

Oh!! Very funny..!! Its an inteview question.
I mean if they were talking about in picture format or any else then which type of variable we have to use??

[<M/>]

I am pretty sure pixel's solution is pretty effective...

[pixelsoul]

Yeah, well the question wasn't a very good one, and stunk of a trolling. Now that I understand that you really did have an honest query here...

If I was asked how to store an image in MySQL, I would probably respond with "I can tell you how, but the question should be why?". It's really not a good practice/solution, and should be avoided. What you should do is store the images in directories, and then store their location and other data in the database.

But I digress, if you were going to store an image in the database, it should be stores as a blob or longblob.