Re: data types

From: Heggelund <d92hegge_at_ix_prod.hfk.mil.no>
Date: 1997/04/03
Message-ID: <1997Apr3.071242.8931@ix_prod.hfk.mil.no>#1/1

Hi,
the datatype varchar2 (and varchar) in Oracle7 has a max length of 2000 characters.

In Oracle version 6 the max length for char is 255.

Rgds
Steinar Heggelund

Son To (son_at_blue.seas.upenn.edu) wrote:

: can oracle support a varable length char greater than 255?
: I need to store text information containing about 1000 characters and
: be able to search the text. BLOB are out of the question becuase it cannot
: be searched.

: thanks for any info,
: Son

--

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.

Received on Thu Apr 03 1997 - 00:00:00 CST