Re: DB Design: Storing Text... Compression...

From: Michael Bierenfeld <michael.bierenfeld_at_ibsgmbh.de>
Date: 1997/08/20
Message-ID: <33FB0C91.8003A31D@ibsgmbh.de>#1/1

Michael Agbaglo wrote:

> While designing a DB for maintance contracts the following problem
> occured:
>
> How can Text stored in a DB ? If I decide to use LONG RAW... how do I
> perform an
> INSERT INTO ... ? Does Oracle provide a compress function ?
> Can I call 'gzip' from a trigger ?
>
> Does Oracle 8 provide better solutions than Oracle 7.3 ?

We have done the same to store BLOBS (BinaryLargeObjects). You have to write a Pro*C PGM (or something similar) to access the DATA stored in LONG RAW Columns.

If anybody has a better Idea pls let me know.

Michael

Rem: Why do you nedd LONG RAW to store Text !?! Received on Wed Aug 20 1997 - 00:00:00 CDT