June 6, 2005 at 1:15 pm
Hi,
I am working on the asp.net web recruiting application for HR department, which will save applicant's resume and cover letter into a SQL Server 2000 table, with 3 columns, Applicant_ID, Resume, Cover_Letter. I am thinking to save Resume and cover_letter as image data type columns. Can someone give me a direction about how to save the uploaded resume and cover letter to table and if it's saved into the image type of table will be the easiest way to do it?
What to deal with different formats of uploaded resumes?
I also give user another option to copy/paste the resume and coverletter. Can I simply save the copy/paste resume and cover letter into text field column?
Any ideas is appreciated.
June 6, 2005 at 1:21 pm
Assuming that these can come under many different formats, I'd simply save then directly on the server's hd and just save the path to the db. Just make sure that those files get backed up too.
June 6, 2005 at 1:44 pm
If you don't want to preserve the formatting you can save the resume and coverletter as text fields - otherwise you're better off following Remi's advice...
Here's a link to a similar post...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=185007
**ASCII stupid question, get a stupid ANSI !!!**
June 7, 2005 at 2:14 am
Just to avoid all the mess with all different formats at the beginning you could convert all the documents into a common format, like PDF, or JPG or TIFF.
After that you can choose between storing thos files as image datatype or just store the path
Bye
Gabor
June 7, 2005 at 2:24 am
Read this http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx closely and decide then which way to go.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 7, 2005 at 6:37 am
I have been forced to do this both ways, store the object in a blob and/or as a file on the network. I have always preferred to store the file in it's native format on the server and place the file path and object type into the database. I find that it keeps the database smaller and more efficient.
On a side note, since you are delaing with text type of objects only it may be better to convert all of the text to PDF's and store them on the network. This way your app only has to deal with one file format and can be more easily managed.
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply