Space Required to store a file in database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi,

I had a query on sql database, we know we usually store files of

different type in sql database and its helpful for searching and

retrieving the documents from the database, but one query i had was

related to the amount of space required to store the files in the

database. For Eg., say i have a word document which is of 5Mb thn how

much space does it occupy in the database if i store it in binary
format

b'coz i know it'll occupy less than the original file size but i
wanted

to knw exactly how much space it'll take in the database and y?

my mail-id is apondu@xxxxxxxxx, if someone knows the answer then
please

let me know

Thanks for the response and help people here are providing

Regards,
Govardhan.

.

Relevant Pages

  • RE: Store Added Value List Items
    ... You could even union that query with the actual list from the form ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)
  • Re: Involved query / possible over Access assistance.
    ... and that it related to normalization. ... >> This is the idea I want to try to implement in an access database. ... I want to store the dayof the week that the event ... >> I want to then do a query for a given week. ...
    (microsoft.public.access.queries)
  • Re: Form
    ... Some instruction of the fundamentals of database design may be in order. ... which is to say a table or query should be selected as its Record ... If you want to store data in the table by way of a form (which should always ... query as the form's Record Source, and select a field from the Record Source ...
    (microsoft.public.access.forms)
  • Involved query / possible over Access assistance.
    ... This is the idea I want to try to implement in an access database. ... I want to store the dayof the week that the event ... I want to then do a query for a given week. ... point during the week 1) display which dayof the week, ...
    (microsoft.public.access.queries)
  • RE: List of options
    ... > Private Sub StoreLstBxSelBtn_Click ... > of the field to store the temporary data in. ... > adds your question and the answers to the database of answers. ... >>> the list box can be set to this query. ...
    (microsoft.public.access.forms)