php - Image save in database

Question

I want to save an uploaded image to database. Now my question is:

1. What should be the data type for SQL Server 2000 for image? a. image b. varbinary

2. what is the code for saving image in database?

3. How to retrieve the image from database and show?

Please refer me any tutorial or guidline. Or if you can please share with me.

Thanks in advance.

Answer 1

The data type should be text because the best way to save an image to a database is to save its path. Let your OS do the job of storing the actual files.