Re: Varchar2 and maximum allowed

From: José Antonio Morcillo Valenciano <jamv_at_gtt.es>
Date: 2000/01/31
Message-ID: <38953BBB.D1F63C7B@gtt.es>#1/1

The maximun is 4000 bytes oracle 8.0.5

Jose

Thomas Muller wrote:

> Kinna Patel <kinna_at_qmark.co.uk> wrote in message
> news:3891cc29.29195431_at_news.demon.co.uk...
> > I currently have an Access database with a memo field in it. I have
> > mapped the memo field to a VARCHAR2 field type under Oracle and set
> > the limit to 2000.
> >
> > Does anyone know the maximum amount of text that can be entered in a
> > varchar2 field type?
> >
> > Thanks in advance.
>
> The maximum length of the VARCHAR2 datatype is 2000 bytes.
>
> --
>
> Thomas
Received on Mon Jan 31 2000 - 00:00:00 CST