RE: FN-FORUM: SQL Server and Word Documents

date posted 1st April 2004 23:49

If you want to do that then the easiest way is to have whatever is
storing the word document into the DB also create a text only version of
it. If you were to open up a word doc in a text editor (Which is the
only way that you'll be able to do a search in SQL) then you'll see the
problem - it's unicode based so you'd have to take that into
consideration when saving.

IF you think about the processes involved then the easiest way is to do
the hard work when saving (which shouldn't be very often) compared to
the searching which you'd think would be a regular thing.

Hope this helps

Cheers
ANdy
=20

-----Original Message-----
From: John Kyle [EMAIL REMOVED]
Sent: Thursday, April 01, 2004 9:55 PM
To: Andy Macnaughton-Jones
Subject: FN-FORUM: SQL Server and Word Documents


I have been searching google for a bit and have not got very far with
this one. I would like to store Word documents in SQL Server, I know I
will have to use the varbinary field (BLOB equivalent). But I would also
like to be able to search the word douments directly in the database.

If I store the word docs in binary format (base64 encode) then I guess I
will have problems searching them etc. Is it possible to store the
documents in SQL Server and be able to search them also or is this just
not possible???

Any help appreciated, I have found some stuff to do with asp but I am
looking at ASP.NET/c# in particular and have come to a bit of a dead end
(is it me or is it becoming more difficult to find relevant stuff with
google than it was 6-12 months ago......)


Best Regards

John Kyle


--
** Get all the Freelance Work you Can Handle * The Web Design Business
Kit will show you proven tactics and strategies for marketing your
business, winning bids, managing projects and pricing your work. Free
Shipping Worldwide.
Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4

To advertise here: http://www.freelancers.net/advertising.html