Re: Large Text Columns in Oracle and OPO

On Tue, 07 May 1996 08:22:59 -0700, Hagen Finley <hagen_at_violet.berkeley.edu> wrote:

>In the manuals for Oracle I have read it is possible to define very
>large (30K) text columns - a possiblity which would be useful to me.
>However, I have also found that VarChar() tops out about 2k in OPO.
>Also, my previous experience with this sor to thing is that the buffer
>for inserting data into a column of this size peaks at a level well
>below the 30k water mark. So my questions are: Am I correct in my
>understanding that I can define columns of this size? Is there a means
>by which that column can be appended and read in OPO? What buffering
>issues would I need to address in order to insert into these columns
>(OPO or SQL+32)?

The long data type in Oracle defines a text field of upto 2GB. Unfortunately there is no way to format this field. Also you can only have one of these columns per table. You bind an OPO text box to one of these fields and it should handle entry into it. I admit I have never tried this. One other problem with Long columns is that you can't use any of the SQL pattern mathcing functions to search in it. Also current version of OPO has a problem with multi-line text boxes. We are currently looking at using an OCX and using the Long Raw column to handle large comment fields.

Kasu Sista
Links Technology Corp. Received on Wed May 08 1996 - 00:00:00 CEST