Re: Varchar2 and maximum allowed

From: Roberto Camara de Carvalho <roberto.camara_at_openlink.com.br>
Date: 2000/01/30
Message-ID: <872prb081k@enews3.newsguy.com>#1/1

The maximum lenght for VARCHAR2 fields is 2Kb for Oracle7 and 4Kb for Oracle8.
Why don't you create the field as LONG datatype (up to 2 Gb) ?

Kinna Patel escreveu na mensagem <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.
Received on Sun Jan 30 2000 - 00:00:00 CST