Re: VARCHAR2 compress

Thanks for the comment.

In fact I'm doing something very similar (I'm populating the column with a compressed string created using java.util.zip) but wanted to canvas the field for Oracle compressed datatypes in-case I was performing an additional and unnecessary action. Regards
Colin

"Richard Armstrong" <richard.armstrong_at_juno.demon.co.uk> wrote in message news:<1024695387.23505.0.nnrp-13.3e3123e3_at_news.demon.co.uk>...
> Could you compress the strings first using a tool like PKZIP then store them
> in a binary field like a BLOB?
>
> Richard
>
> "Colin McGuire" <colinandkaren_at_lycos.co.uk> wrote in message
> news:ab6cea37.0206200018.727af1ee_at_posting.google.com...
> > Hello - I have squillions of long strings that I would like to store
> > in an Oracle 8 database. Because of the size of the strings I would
> > like them to take the minimum amount of space in my database/on the
> > server.
> >
> > The contrived SQL I would like to enter would be something like
> >
> > CREATE TABLE tblTest(id NUMBER PRIMARY KEY,
> > storedate DATE,
> > staffid VARCHAR2(5),
> > otherdata COMPRESSED VARCHAR2(3000)
> > );
> >
> > So how is this done or does it need to be done (ie does Oracle
> > automatically compress 'otherdata' for me) ?
> >
> > Thank you
> > Colin
Received on Mon Jun 24 2002 - 02:57:42 CDT