Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: store zipped file in Oracle

Re: store zipped file in Oracle

From: mark tomlinson <marktoml_at_hotmail.com>
Date: Sun, 16 Jan 2000 17:21:33 -0500
Message-ID: <t1h48sgbup230u8s93po8q5m56udgsvlt4@4ax.com>


On Sun, 16 Jan 2000 02:27:37 -0500, Rus Rayburn <rus_at_localhost.localdomain> wrote:

>Haven't seen this done before, but it seems you could store the ziped file
>in a table with the BLOB type. Display, however, would be a problem.
>
>You might want to try storing the text files in VARCHAR(2) fields.
>VARCHAR(2) uses only enough space to hold the data, ie column set to
>VARCHAR(2)5000 holding a 937 character file would only use 937.
>

Not on Oracle. Try VARCHAR2(4000) Max on 8.x. 2000 max on 7.x Received on Sun Jan 16 2000 - 16:21:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US