Web application CV

hello friends,
I have one question. In a web application where i have to save the candidates Curriculum when it is uploaded can u suggest me how should i save the file uploaded.
1. as a file
2. or as a column value in the database
Which database Management system would be suited to do such type of application

Is it a file u r uploading or some info? Also I don't know what CV in your thread title stands for so I might not be right with my reply but i will try.

If its some info u want to save to database, then u don't need to use a file to send to database. Thats what a database is for - to store information efficiently instead of storing them in files. U can use stored procedures (which are basically SQL functions precompiled on db server - look them up for more info) to send info to database. So - u create the stored procedure on server side and then simply call them from your application, passing the info in parameters to the stored procedure.

As to the type of DB to use for this, any should be fine. MySQL is free

CV is "Curriculum Vitae" or "Resumé" - generally a MS Word document! Just off the top of my head, would a BLOB be good for this type of storage?

Stu!

thanks stuyg,
I am working out with the same datatype. As i have been working in Oracle from last 3 yrs i wated to ask that after u have uploaded CV as a file in a column while doing some operations on that column which DBMS with provide better flexibility of traversing.
I know know that Blobs in oracle can be used as normar varchar to search any word in it. But anyways i got the permission to use Oracle, so will be using oracle. I will write up in this thread i proceed doing the service.

Hi,

I was successful to upload the file in the database in LONG RAW in oracle 9i . Now can anyone suggest me how to i can download the LONG RAW data (in the same file by which it was uploaded) to the clients destination.
I have the following structure of the table
Uploadid Number
FileName varchar2
BINARYFILE LONG RAW