Re: VARCHAR2 compress

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 Fri Jun 21 2002 - 16:36:25 CDT