Re: What data system can I use for storing documents?
- From: "Val Mazur \(MVP\)" <group51a@xxxxxxxxxxx>
- Date: Thu, 28 Apr 2005 21:03:56 -0400
Hi,
It depends on a database. In a case of Access database, it is better to
store just a file names, because if you try to store your binary documents
inside of the database, then it will grow very fast and you will get to the
point when you cannot insert information anymore. In a case of SQL Server
you could store documents as a binary using image datatype. But searching is
not provided for the binary types. If you need to search some text inside of
the documents, then it is not a database's task. It should be some sort of
search engine designed specifically for the documents
--
Val Mazur
Microsoft MVP
http://xport.mvps.org
"Paddy" <Paddy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:13D7757B-CB4C-49AF-9A2D-616F0A0CC9BB@xxxxxxxxxxxxxxxx
> Hi,
> This is a bit of a general question.
>
> Can someone please advise me as to what options I have for Databases that
> hold files?
>
> I'll be attaching PDF's and Word files. I would also like to be able to
> search within the files.
>
> Thanks
>
> Paddy
.
- References:
- Prev by Date: Re: ORACLE CLOBS IN ORACLE STORED PROCEDURE
- Next by Date: Re: Update database with a dataset
- Previous by thread: What data system can I use for storing documents?
- Next by thread: ORACLE CLOBS IN ORACLE STORED PROCEDURE
- Index(es):
Relevant Pages
|
|
