Re: Varchar2 and maximum allowed

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: 2000/01/28
Message-ID: <86st3l$akj$1@news7.svr.pol.co.uk>#1/1

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?

2000

You'd be better off using a LONG datatype for this I think! Received on Fri Jan 28 2000 - 00:00:00 CST