Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: store zipped file in Oracle
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
![]() |
![]() |